Using Criteria in query 1

[Lost500]

hi and thanks for reading.
I have a query where i have two date fields the original and the extended. the extended field is only filled out when the date has been extended what i want to do is include the original date but if the extension has been taken only include the extended date. i don't know if that makes sense but maybe use an if then statement in the query or something with report im lost. any help would be great!

 

[PHV]

Have a look at the Nz function:
Nz([extended date],[original date])

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Lost500]

Thanks PHV! that works great!