powerlock2005
Technical User
All,
I have a query (qry_license) that is tied to a table, and two fields I will be referring to are: dtLicenseBegin and results.
I have this expression for the results:
results: DateAdd("d",-60,[dtLicenseBegin])
So if I enter a date of 12/6/05 for the dtLicenseBegin, the results field will give me 60 days prior to 12/6/05.
I want to tie qry_license to a report, and I only want to show the records that are within the 60 days before the 12/6/05 date occurs.
Example: When 60 days prior to 12/6/05 occurs, which would be something like 10/6/05, I want the report to start showing that record until 12/6/05.
How do I accomplish this?
Please help someone.
Thanks,
I have a query (qry_license) that is tied to a table, and two fields I will be referring to are: dtLicenseBegin and results.
I have this expression for the results:
results: DateAdd("d",-60,[dtLicenseBegin])
So if I enter a date of 12/6/05 for the dtLicenseBegin, the results field will give me 60 days prior to 12/6/05.
I want to tie qry_license to a report, and I only want to show the records that are within the 60 days before the 12/6/05 date occurs.
Example: When 60 days prior to 12/6/05 occurs, which would be something like 10/6/05, I want the report to start showing that record until 12/6/05.
How do I accomplish this?
Please help someone.
Thanks,