How do I retrieve the most recent date from an access database

TheMooseRI
15 pts.
Tags:
Access Database
Microsoft Access
Microsoft Access 2003
I am building a report in Access 2003 and am trying to pull data based on the most recent service call for a customer. There is typically several service call dates for each customer, but the only record I am concerned with is the most recent date.
Asked: Last updated:
Related Questions

Answer Wiki

Thanks. We'll let you know when a new response is added.

You probably need to write a SQL query to do this. Try something like this:

select * from service_call where customer_id = form.customer_id and call_date = (select max(call_date) from service_call where customer_id = form.customer_id);

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • steviekoks
    You can do it with accdb repair tool

    10 pointsBadges:
    report
  • TomLiotta
    The Access repair tool is no help for this question at all. -- Tom
    125,585 pointsBadges:
    report
  • Mlwonio
    Make sure the date is stored in a true Date data-type field for this to work.
    90 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: