philfer
03-20-2010, 06:38 AM
Hi,
I have a database table which holds an import file.
There are three date fields (as well as loads of other fields):-
Maturity date Final Maturity Date Limit Exp Date
I want to run a query that pulls a few fields and then a field called "max Date" which has the latest of all three dates.
In excel you can use the "max" funtion with dates to get the last date.
I tried this in the expression builder in query designer but with no success.
Can anyone think of how I can do this?
(I dont like using custom VBA functions in query design as I find it slow!)
Cheers
Phil
I have a database table which holds an import file.
There are three date fields (as well as loads of other fields):-
Maturity date Final Maturity Date Limit Exp Date
I want to run a query that pulls a few fields and then a field called "max Date" which has the latest of all three dates.
In excel you can use the "max" funtion with dates to get the last date.
I tried this in the expression builder in query designer but with no success.
Can anyone think of how I can do this?
(I dont like using custom VBA functions in query design as I find it slow!)
Cheers
Phil