Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How code this query?

Status
Not open for further replies.
ZABADAK

ZABADAK

Programmer
Feb 24, 2005
39
US
I posted this before buy never got a suitable answer and am still struggling with the problem....

I have a table of service request (SR) data extracts. There is no unique key. The extract can be run for any time period and each extract may or may not contain the same SR number. Each extract record has a run date.

What I need to do is extract all of the columns for each unique SR number for the latest run date record in the table. How do I do this? I must somehow group by SR number and then take the SR record with the MAX run date. Any help much appreciated.
 
Sort by date Sort by votes
can you provide some sample records and what you want your results to look like?


Leslie
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Question
Query expression negative to a 0
Replies
6
Views
254
dhookom
dhookom
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
781
strongm
strongm
C
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
194
OzFoxy
OzFoxy
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
2K
dhookom
dhookom
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
4K
combo
combo

Part and Inventory Search

Sponsor

Back
Top