Show latest record according to date

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

Guest

Hi,

I'm trying to create a query that show the latest recorded according to the
date. I have a table with mix orders and I would like to create a query
sorting to Group, but only show the latest record for that group.

Any help would be greatfull.

Graeme
 
One way is to create a group by query that return order Group and the latest
datre
SELECT GroupName, Max(OrderDate) AS MaxOrderDate
FROM MyTableName
GROUP BY GroupName

And then create anothe query that join the order table and the query above,
by the group Number and the date, that will return the latest order for a
group

HTH
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

numbering records according to date and ID 2
Find the most recent record of each payee by date. 16
Include records even if date is null 4
how to return record with latest date 1
Multiple records 1
Problem Sequentially Numbering Records 2
Problem with "Latest Date" Query 9
Running a query that only shows the latest entry 2

Back
Top