Translating SQL from SQLServer to Access 1

[jmeadows7]

I want to retrieve the max value of a column or return 0 if it is NULL. I know how to write it in SQL 92 -
SELECT
CASE
WHEN max(loc_csreq_id) IS NULL THEN 0
ELSE max(loc_csreq_id)
END
FROM csreq

Anyone have a quick translation to Access for me?

Thanks!!

 

[Remou]

Something like:

Nz(Max(loc_csreq_id),1)

 

[jmeadows7]

Thanks,

I still have to make it work with a WHERE clause, but I think I can handle that. I've never used NZ before - thanks for the tip!

 

[Remou]

[tt]SELECT Nz(Max(loc_csreq_id),1)
FROM tblTable
WHERE Field1='AAA' AND Field2=200 AND Field3=#12/31/2007#[/tt]

 

[jmeadows7]

Remou - thanks - your tip came in before I even had a chance to get back to try it.

Worked perfectly.

Thanks,