Last Date

[ci]

In my table tracking chemical usage I want to find the
most recent date that each chemical was used. Is it the
DMax function that will give me that and how would I write
the expression. Thanks for the assistance.

 

[John Vinson]

In my table tracking chemical usage I want to find the
most recent date that each chemical was used. Is it the
DMax function that will give me that
Yes.

and how would I write
the expression.

I don't know, since I don't know the name of your tables, the name of
the date field, how chemicals are identified, or where the used date
is stored in your table structure. My telepathy module is out for
repair, or maybe I could. :-{)

But it would be something like

=DMax("[datefield]", "[tablename]", "[ChemicalID] = " & [ChemicalID])

or, if the chemical identifier is a text field,

=DMax("[datefield]", "[tablename]", "[ChemicalID] = '" & [ChemicalID]
& "'")

Thanks for the assistance.

You're welcome, hope it helps.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps