How can I retrieve with a query the first and the last date of a data base?
How can I retrieve with a query the first and the last date of a data base?
Assuming you mean Table(s) and/or Queries when you say DataBase ..
SELECT MAX(DateField) FROM Table
.. should get the latest date. Use MIN instead of MAX for the earliest. You can make the FROM (and associated WHERE) clauses as complex as you can with any other query.
Enjoy,
Tony
---------------------------------------------------------------
Give a man a fish and he'll eat for a day.
Teach him how to fish and he'll sit in a boat and drink beer all day.
I'm (slowly) building my own site: www.WordArticles.com
thank you!
To Admin: Consider the thread closed.
G.