Microsoft Access date formulas

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

Guest

I am trying to get a report showing the amount of days that have passed since
a client has been contacted and I have uploaded 2 microsoft excel tables into
access and I need to find out if there is a formula I can enter that will
show the most recent date entered for each client number. And if I haven't
gone through enough of the steps to be able to do this, what are the steps
that I need to take?
 
I am trying to get a report showing the amount of days that have passed since
a client has been contacted and I have uploaded 2 microsoft excel tables into
access and I need to find out if there is a formula I can enter that will
show the most recent date entered for each client number. And if I haven't
gone through enough of the steps to be able to do this, what are the steps
that I need to take?
Click to expand...

Bear in mind we cannot see your database and have no way to know how
you have your tables constructed or your date values entered...

All I can suggest is that you create a Query based on your table; use
a "Subquery" as a criterion: put

=(SELECT Max([datefield]) FROM tablename AS X WHERE X.ClientID =
tablename.ClientID)

using your table and field names of course. This will return just the
most recent date for each client.

John W. Vinson[MVP]
 
Back
Top