Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
CASE WHEN Statement in MS Access query
November 08, 2010
Can anyone expaline about
how to write CASE WHEN Statement in MS Access query
Posted Date: November 08, 2010 Points: 5
You can do it by,
Select Case AnyNum
Case 1 To 10
[Pole] = "North"
Case 11 To 20
[Pole] = "South"
Case 21 To 30
[Pole] = "East"
[Pole] = "West"
Hope this helps
To post reply
Related Questions Related Questions
How do we use CASE WHEN statement in ms access query and please give me sample?
Can we use Case Statement in Update Query?
how to write Query to retrieve column names in ms access
like query in ms access
Ms Access databse query
Oracle CASE When statement
Used case in select query
getting Error for accessing Data from MS Access using Select Query
What is Code Access Security in .NET
query handling in asp
Latest Forum Questions From The Same Category
Xamarin for Visual Studio 2010/2012 ?
How to attach Google Plus authentication system in Windows 8.1 phone using c#
Installing Visual Studio 2012 on Windows 7
Can anyone suggests me a laptop on which I can install any OS ?
Software freelancers who work from home, need a license?
help me problem instal graphique card on i5 intel fujitsu e752 hd4000
Extracting data from different websites to excelsheet
Please let me know the cost/exam fee associated with the Microsoft ASP.Net certification
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend