Discplaying the most current date in a secries of dates

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

Guest

This is the delima i face. the main table is set up to be like the main body
of a trouble ticket and the bottem half which appears to be another seprate
table (inside of the main one) has a collum for the ticket number, call date,
call time and so fourth. the date and time collum (Seprate collums) is not
set to auto populate it is manual entry and does not appear to be directly
formatted for dates. This is a working databace that the group is using so i
donot want to edit the main table. we are alloud to create querries. so i
created one and associated it with the "calldate" field and it shows the date
in the first row of all of the records. i like to find out a formula or easy
way do only get it to discplay the most current date.
 
Your table probably has a primary key field, so you can get the most recent
date that matches that number by using DMax(). The expression to put into
the Control Source of your text box would be something like this:
=DMax("MyDateField", "MyTable", "[ID] = " & Nz([ID],0)

If you actually wanted more than just the date, see:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm
 
Back
Top