Last Date in query

[Guest]

I have a series of donations and a request for the last date and gift given.
I've tried using the "Last" function, but it comes up with dodgy results,
regardless of where/how I sort the date. Not only is this something I need to
know how to do now, but also something that will be required of my job on a
weekly basis. Short of creating a new table and manually deleting the older
dates, is there any way I can find the date and amount of the last donation?

(and before it's suggested: Yes, this column is a date/time column, not a
text)

 

[Guest]

Hi,
use MAX instead in a totals query.
Last is unreliable at times as you recognized.
HTH
Good luck

 

[Guest]

Try this in a query

Select * From TableName Where DateFieldName =
DMax("DateFieldName","TableName")

 

[Van T. Dinh]

See The Access Web article:

http://www.mvps.org/access/queries/qry0020.htm

for a number of different methods.