HELP!! Emergency Select 25 records only

[MaxEd]

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.

 

[RobSchultz]

SELECT TOP 25 ...

HtH,

Rob

-Focus on the solution to the problem, not the obstacles in the way.-

 

[MaxEd]

I used a ordered by DESC and it returned all the records

-Laughter works miracles.

 

[amorous]

Try something like this:

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


-VJ