bigest date in the date field

F

Faisal

How to find Bigest date in a date field for a query.


As i use max() function in date field it give any error message:Cannot have
aggregate function in WHERE clause <clause>. (Error 3096)


Regards
Faisal
Riyadh
 
J

John W. Vinson

How to find Bigest date in a date field for a query.


As i use max() function in date field it give any error message:Cannot have
aggregate function in WHERE clause <clause>. (Error 3096)


Regards
Faisal
Riyadh
Click to expand...


This may be a better case for a Top Values query:

SELECT TOP 1 <whatever fields you want to see>
FROM tablename
ORDER BY datefield
 
Top