criteria and Access 1

[SharonMee]

Hi all:

I am setting up a query in Access.

I have 2 date colums, Since Date & Logged Date. How do I say "If Since date" is null, = logged date.

Thanks

 

[mhcruella]

NewDate:iif([Since Date] is null,[Logged Date], [Since Date])

Mich

 

[SharonMee]

thanks, it worked!

 

[PHV]

Another way:
NewDate: Nz([Since Date], [Logged Date])

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