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

HELP!! Emergency Select 25 records only

Status
Not open for further replies.
MaxEd

MaxEd

Technical User
Jul 3, 2002
407
US
I need help to return only 25 records from the tables based on a specific date and city. I need it done ASAP... THANKS!

-Laughter works miracles.
 
Sort by date Sort by votes
SELECT TOP 25 ...

HtH,

Rob

-Focus on the solution to the problem, not the obstacles in the way.-
 
Upvote 0 Downvote
I used a ordered by DESC and it returned all the records

-Laughter works miracles.
 
Upvote 0 Downvote
Try something like this:

SELECT TOP 25 FROM yourtablename WHERE City='"&cityvar&"' AND datefield='"&datefield&"' ORDER BY datefield DESC


-VJ
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
472
lameid
lameid
Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
294
Swi
Swi
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
139
Andrzejek
Andrzejek
monkeysee
  • Locked
  • Question
Select Query for append query 1
Replies
12
Views
236
monkeysee
monkeysee
serino
  • Locked
  • Question
Adding Records between two ranges 2
Replies
12
Views
246
serino
serino

Part and Inventory Search

Sponsor

Back
Top