Solved Only show last date on 3 columns (1 Viewer)

[Number11]

So i need to Max on 3 fields within a table

StartDate
EndDate
OrderDate

Can i use MAX for all 3, as i think this is not working for all 3

 

[Number11]

found it using this..

Max of multiple columns

It would appear that you have not pasted the function into a module in your database.

www.access-programmers.co.uk