D
David
I am trying to run a report from a form looking for records that are older
than the number of days entered in a control on the form (the control in
called days.) Before I ran the report, I wanted to validate, through a
DLookup function, that there were records in the dataset.
IN the criteria, I need to look for records which meet the following:
The [RelDate] field is Null and the [EnteredDate] field is older than (less
than) the current date less the amount of days entered on the form.
I was trying something like:
"[RelDate] Is Null And [EnteredDate] < Format(Date()- Me.Days,
"\#mm\/dd\/yyyy\#")"
I know I am way off on this, so any help would be appreciated.
than the number of days entered in a control on the form (the control in
called days.) Before I ran the report, I wanted to validate, through a
DLookup function, that there were records in the dataset.
IN the criteria, I need to look for records which meet the following:
The [RelDate] field is Null and the [EnteredDate] field is older than (less
than) the current date less the amount of days entered on the form.
I was trying something like:
"[RelDate] Is Null And [EnteredDate] < Format(Date()- Me.Days,
"\#mm\/dd\/yyyy\#")"
I know I am way off on this, so any help would be appreciated.