If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
bigest date in the date field
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 |
#2
|
|||
|
|||
bigest date in the date field
On Sun, 16 Mar 2008 21:23:00 -0700, Faisal
wrote: 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 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 -- John W. Vinson JVinson *at* Wysard Of Info *dot* com |
Thread Tools | |
Display Modes | |
|
|