Hi,

Where do i set this value?

Thanks,

Damien

Hi Veteran,

Given that it should be <> 0 then how would I handle the fields where they are = 0? I have only put the 0.0001.... there as a place...

Hi Everyone,

Thank you so far for your replies to my newbie question.  The full SQL for that query is:

SELECT    

MAX(dbo.cit.citModID) AS mid,

dbo.cit.citID,

MAX(cit.citCamID) AS cam_id,

MAX(CASE dbo.cit.citBudget WHEN...