Earliest and latest date in a field

  • Thread starter Thread starter Shane Nation
  • Start date Start date
S

Shane Nation

I am using Access 2003, but I need to covert this backwards to Access 97.



I have imported a text file which has created a table. This table contains a
date field (Short date format) which contains dates (funny enough).



I need to display in a form the earliest and latest date in this field, so I
can display to the user what date range has just been imported.

The text file will be imported daily, with a different date range each time.
The user will just click a button on a form which runs a macro to import the
text file and create the table.



Please can anyone tell me how to do this?



Thanks



Shane
 
Create 2 text boxes on a form. Set the control source of the first box to
=DLookUp("Max([DateField])","[TableName]")
Set the control source of the second box to
=DLookUp("Min([DateField])","[TableName]")
 
Thanks that is great

Dennis said:
Create 2 text boxes on a form. Set the control source of the first box to
=DLookUp("Max([DateField])","[TableName]")
Set the control source of the second box to
=DLookUp("Min([DateField])","[TableName]")

Shane Nation said:
I am using Access 2003, but I need to covert this backwards to Access 97.



I have imported a text file which has created a table. This table
contains a
date field (Short date format) which contains dates (funny enough).



I need to display in a form the earliest and latest date in this field,
so I
can display to the user what date range has just been imported.

The text file will be imported daily, with a different date range each
time.
The user will just click a button on a form which runs a macro to import
the
text file and create the table.



Please can anyone tell me how to do this?



Thanks



Shane
Click to expand...
Click to expand...
 
Back
Top