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

15 pts.
Tags:
Access 2003
Access Database
Microsoft Access
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.

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following