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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select Most Recent Date without using a group select

Status
Not open for further replies.
mwhalen

mwhalen

Programmer
Oct 31, 2000
217
CA
Is there a way to select the most recent dated record without using a group select? In some reports I have I will want to save the group select for some financial info so I don't want to use the group select on my max date as I think the two would conflict.

Please help!!! Thanks.
 
Status
Not open for further replies.

Similar threads

john432
  • Locked
  • Question
Select Expert
Replies
2
Views
157
john432
john432
mmck1964
  • Locked
  • Question
Using "OR" to select data
Replies
4
Views
398
mmck1964
mmck1964
Cpreston
  • Locked
  • Question
Only Select certain rows 1
Replies
7
Views
387
Cpreston
Cpreston
Cpreston
  • Locked
  • Question
Select Top 2 rows where field = 2,3,4 and 5
Replies
1
Views
246
Cpreston
Cpreston
T
  • Locked
  • Question
Date comparison Formula
Replies
2
Views
427
TPG_IT
T

Part and Inventory Search

Sponsor

Back
Top