date in text box? (1 Viewer)

[dgoulston]

i have a table which has lots of fields but the only one im interested in is the date,
(fieldname = date)

i have a form on this for i want to display the first date and the last, the dates are not in order, so i have a query that works out what the earliest and latest dates are e.g.
date:
7/1/02 14:13:34
8/1/02 11:12:43
1/1/02 13:25:32
4/1/02 11:42:32
5/1/02 06:21:32
2/1/02 11:14:33
3/1/02 15:23:23
6/1/02 11:22:43


so in the first text box i would want 1/1/02 displayed
and in the second one i would want 8/1/02

the dates are not in order in the table. as i have shown with the example above... what is the easiest way to do it either accssing the query that sorts the dates out itself, or accessing the table directly.


thanks in advance.
DAL

 

[antomack]

Try the DMax and DMin functions to get the latest and earliest date.

 

[dgoulston]

thank you soo much, ur a life saver,,, lol

DAL