First and last date in a table for use on a form

  • Thread starter Thread starter Harmannus
  • Start date Start date
H

Harmannus

Hallo,

I have a tblBilling with a field BillingDate.

How do i dertermine the first and the last date in this table for use on a
form as basis for a rapport where a want the selection fields DateFrom en
DateUntill showing default the First date in DateFrom and Last date in Date
Untill?

e.g.
DateFrom default value= FieldBillingDate.FirstDate
DateUntill default value=FieldBillingDate.LastDate

Thanx in advance for any tips.

Regards,
Harmannus
 
DateFrom default value= FieldBillingDate.FirstDate
DateUntill default value=FieldBillingDate.LastDate
Click to expand...

You could use

DMin("[FieldBillingDate]", "tablename")

for the earliest, and DMax() for the latest.
 
Hallo,

Thanx for the tip!

Great help.

Regards,
Harmannus

John Vinson said:
DateFrom default value= FieldBillingDate.FirstDate
DateUntill default value=FieldBillingDate.LastDate
Click to expand...

You could use

DMin("[FieldBillingDate]", "tablename")

for the earliest, and DMax() for the latest.
Click to expand...
 
Back
Top