Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dates

Status
Not open for further replies.

at51178

Technical User
Mar 25, 2002
587
US
Hey guys

I created a form that has a column with dates in them

I would like to create a two text boxes one with the earliest date and one with the last date so for example if i had records from 01/01/00 through 03/01/02 I would like the text box to show the first record or the oldest record which would be 01/01/00 and the last record 03/01/02. I would also be filtering this form on a daily basis so it is important that the text box updates itself upon filtering


 
Couldn't you use the min and max function in your query to solve this problem???
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top