Recent date query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that tracks tools. How can I do a
query based on the most recent date a tool was
assigned/unassigned?

Thank you so much for any help.
 
I have a database that tracks tools. How can I do a
query based on the most recent date a tool was
assigned/unassigned?

Thank you so much for any help.
Click to expand...

Use a criterion on the date assigned of

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

using your own table and fieldnames of course. If the tool identifier
is Text rather than numeric, you'll need quotes:

"[ToolID] = '" & [ToolID] & "'"
 
THANK YOU VERY MUCH!
-----Original Message-----
I have a database that tracks tools. How can I do a
query based on the most recent date a tool was
assigned/unassigned?

Thank you so much for any help.
Click to expand...

Use a criterion on the date assigned of

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

using your own table and fieldnames of course. If the tool identifier
is Text rather than numeric, you'll need quotes:

"[ToolID] = '" & [ToolID] & "'"


.
Click to expand...
 
Back
Top