Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
munahil
Starting Member
4 Posts |
 Posted - 2008-07-23 : 06:45:46
|
| how can we use IF ELSE , SWITCH statements , and FOR loop in SQL query in ms access? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-07-23 : 06:51:02
|
IF, ELSE, FOR are procedural command, and cannot be used in any query.In T-SQL you have CASE and in Access you have IIF to use in queries.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
|
|
|
IF ELSE, SWITCH and FOR Loop