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!

To return highest issue letter within a group 1

Status
Not open for further replies.
ugly

ugly

Programmer
Joined
Jul 5, 2002
Messages
70
Location
GB
My table consists of two fields, doc and issue. The data looks like-

Doc101, A
Doc102, A
Doc102, B
Doc103, A
Doc103, B
Doc103, C
Doc103, D

I am trying to construct a query that returns the highest letter issue for each doc group. So in the case of the above data my query would return

Doc101, A
Doc102, B
Doc103, D
Thanks for any help here
 
Sort by date Sort by votes
How about:

[tt]SELECT Table1.Doc, Max(Table1.Issue) AS MaxOfIssue
FROM Table1
GROUP BY Table1.Doc;[/tt]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Locked
  • Question Question
Query expression negative to a 0
Replies
6
Views
670
dhookom
dhookom
breezett93
  • Question Question
Query takes 30 seconds - 1 minute to process. Trying to rework it to take 5 or less
Replies
8
Views
694
breezett93
breezett93
BugZap13
  • Locked
  • Question Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
813
mikrom
mikrom
serino
  • Locked
  • Question Question
Help with a Query.
Replies
13
Views
1K
strongm
strongm
mhshane
  • Question Question
Is this the best way to do this query?
Replies
9
Views
435
mhshane
mhshane

Part and Inventory Search

Sponsor

Back
Top