Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IF condition in query
Message
 
To
21/09/2005 10:24:40
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
General information
Forum:
Microsoft Office
Category:
Access
Title:
Re: IF condition in query
Miscellaneous
Thread ID:
01051640
Message ID:
01051883
Views:
6
Use the iif statement like so:

Select [name],[amount],iif([name]="Mike",[amount] * .025,[amount] * .05) as total from table

:)
Ricardo A. Parodi
eSolar, Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform