Use CASE in an MDB Query

[Hfnet]

I currently have a CASE procedure in a project, and I want to use it in an MDB:

SELECT dbo.MainTable.*
CASE dbo.MainTable.PausedJob WHEN 0 THEN 6 ELSE 5 END As PendingNo
FROM dbo.MainTable;

How can I achieve this in an MDB with linked SQL Server Tables?

Thanks

 

[GingerR]

SELECT dbo.MainTable.*, IIf([PausedJob]=0,6,5) AS PendingNo
FROM dbo.MainTable;


Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[Hfnet]

Thanks muchly!