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!

Last Date entered

Status
Not open for further replies.
southboy

southboy

Programmer
Oct 23, 2002
26
US
I have a bills database and I need to find the last date paid for each bill in the bills table so I can start weeding out bills I don't pay on anymore. I'm tring to do this in a query but can't seen to get it. I've tried using the MAX, DMAX, DMIN, datediff and between dates to not avail.
Any suggestions?
 
Sort by date Sort by votes
You should be able to use something on the lines of:


SELECT BillID, Max(Date) FROM tblBills GROUP BY BillID
 
Upvote 0 Downvote
That worked GREAT! Perfect! Your Awesome Remou!
Thanx for the help!
Southboy
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TomSalvato
  • Locked
  • Question
Getting the Monday date from a week number 1
Replies
2
Views
532
TomSalvato
TomSalvato
N2Life
  • Locked
  • Question
Last figure in a text box is partially cut off when conditionally formatted as italics 1
Replies
7
Views
204
N2Life
N2Life
nikademous
  • Locked
  • Question
Go to specific Record based on date
Replies
0
Views
101
nikademous
nikademous
PWD
  • Locked
  • Question
Access 2010 Sort By Calculated date
Replies
7
Views
173
dhookom
dhookom
ECHO Volunteer
  • Locked
  • Question
The expression On Click you entered as the event property setting produced the following error: ..
Replies
6
Views
385
ECHO Volunteer
ECHO Volunteer

Part and Inventory Search

Sponsor

Back
Top