If then

[pungigi]

Can I do some kind of if then in a query???

What I am doing is

Trip Status = S1, SQ or SR
Trip Type countif R then 2 else 1

What I need is to be able to get information based on above TWO criterias.

 

[PHV]

Take a look at the SQL In operator and at the IIf function:
WHERE [Trip Status] In ('S1', 'SQ', 'SR')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Lothario]

use CASE statement...

Something like this...

CASE
WHEN Trip Type= 'R' THEN blahblah=2
Else
blahblah=1
END

-L

 

[PHV]

Lothario, CASE is OK for passthru query to an Ansi SQL compliant RDBMS, not for regular JetSQL.
The Access way is IIf.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Lothario]

Thanks PHV...

I thought i was replying in the SQL Server programming forum...

-L