|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
10-01-2003, 10:38 AM
|
#1 |
|
Member (10 bit)
Join Date: Jan 2001
Location: Birmingham, UK.
Posts: 553
 |
Access CASE WHEN statement
In SQL Server you can use a CASE WHEN statement to SELECT different values conditional on values in the row data.
Is there an equivalent in Access? Cheers DJ |
|
|
|
10-01-2003, 11:12 AM
|
#2 |
|
Professional gadfly
Join Date: Jan 2002
Location: Minneapolis, MN
Posts: 6,364
 |
Not that I know of. However, if you describe what you are trying to do perhaps a workaround can be found.
|
|
|
|
|
10-01-2003, 11:15 AM
|
#3 |
|
Member (10 bit)
Join Date: Jan 2001
Location: Birmingham, UK.
Posts: 553
|
OK if a field Sold is True then PriceString should be returned as 'SOLD'.
If a field Awaiting_Release is True then PriceString should be returned as 'AWAITING RELEASE'. Otherwise PriceString should return the value in the field Price. DJ |
|
|
|
|
10-01-2003, 11:33 AM
|
#4 |
|
Professional gadfly
Join Date: Jan 2002
Location: Minneapolis, MN
Posts: 6,364
|
The good thing about Access queries is that you can use all of the VB stuff. In this case, I think two IIf statements will work nicely:
SELECT IIf([Sold]=True,"SOLD",IIf([Awaiting_Release]=True,"AWAITING RELEASE",[Price])) AS PriceString FROM .... Add whatever other columns you may need. You don't say if it is possible for both Sold and Awaiting_Release to be simultaneously true; if not, then this will work as written. If so, it may be more complicated. |
|
|
|
|
10-01-2003, 11:34 AM
|
#5 |
|
Member (10 bit)
Join Date: Jan 2001
Location: Birmingham, UK.
Posts: 553
|
Excellent I just found the IIf statement myself. Thanks again for you suggestions.
DJ |
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
