Last Date

  • Thread starter Thread starter ci
  • Start date Start date
C

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.
 
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.
Click to expand...

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.
Click to expand...

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
 
Back
Top