Simple (I Think)

[Derrick T. Davidson]

Please be aware super newbie I just figured out there is two F's in if



All I want to do do is get the last date in a query sometimes the cell (field) is blank, I just need something like:

Date: MAX( [Date1], [Date2], [Date3] )

I know this doesn't work cos I tried it already

[ItsMe]

Have you tried the Dmax() function. It may be the simplest aproach. Problem is that you will need to take three trips to the data, once for each field. The other option, to make things a litle faster will require more code.

[JoeM]

The MAX function is an aggregate function that works on a single fields across many records (not checking multiple fields across a single record).
Your question could be indicative of a normalization issue (tables not structured properly).
What do the three date fields represent?
What other information is found in the records?

BTW, the Immediate If statement has two "I"s, not two "F"s!