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

Top of Stack entry

Status
Not open for further replies.
moochdd2

moochdd2

Vendor
Jun 8, 2004
1
0
0
US
I have a sub-form where I am using auto date. I do I ensure that the last entry made, regardless of date is the one that displays on top (first)?
 
Sort by date Sort by votes
Do an ORDER BY on the recordset of the date value. If you want it to be latest date first add a DESC to the order by.
"ORDER BY" is one of the reserved methods of a recordset.

Rollie
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Trying to add hyperlinks to pdfs through form entry
Replies
0
Views
76
renigar
renigar
TrekBiker
  • Locked
  • Question
Spurious Change of Fonts
Replies
3
Views
93
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Hyperlink Text of a field
Replies
1
Views
64
caykamanj1966
caykamanj1966
priac
  • Locked
  • Question
Create a Duplicate of an Existing Record in Microsoft Access but leave some fields blank.
Replies
7
Views
177
Andrzejek
Andrzejek
StevenFromSouth
  • Locked
  • Question
How to join tables to get current price of a product. 1
Replies
3
Views
48
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top