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

is MAX the correct function to use to get the most recent dates?

Status
Not open for further replies.
jgoodman00

jgoodman00

Programmer
Jan 23, 2001
1,510
We have a table which can contain many occurences of a reference number. Each reference number will have an inspection date. Is the MAX function the correct function to extract the most recent date for each refno (i.e. the most recent date per reference number)? James Goodman
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

monkeysee
  • Locked
  • Question
Max Date Qry 1
Replies
3
Views
601
Andrzejek
Andrzejek
BugZap13
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
236
mikrom
mikrom
breezett93
  • Locked
  • Question
Field is being rounded in the export process
Replies
17
Views
710
strongm
strongm
btamsgn
  • Locked
  • Question
How to arrange the values in column heading based on column STT
Replies
10
Views
2K
combo
combo
spartansFC
  • Locked
  • Question
Display Year between 2 dates 1
Replies
1
Views
559
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top