Wierd Date Problem

[Annelie]

I hope someone has an idea how I can accomplish this

I have created a monthly audit report for workers compensation, which looks
at the week ending date of the payroll.

So for example, the policy period is 03/20/04 to 03/20/05 and they want
monthly reports from the 21st of one month to 20th of the next month.
The payweek for this company ends on a Sunday.
So my first reports was for week ending 03/28/04 (starting with workday
03/22) thru week ending date of 04/18/04

This is the correct data, but the insurance company wants the report to show
from 03/21/04 to 04./20/04

On top of that I am picking the dates from an unbound text box from a form.
I am at a total loss, on how I can come up with these dates on the report
Annelie

 

[[MVP] S.Clark]

Insurance companies are... wait I'd better not.

On the form, you state that you're entering the dates, which is good. From
your example, even if you entered 4/20/04, it sounds like your data stops at
the 18th. If this is true, then your query would continue to return correct
results, and nothing changes. (If this is NOT true, stop here.)

So, how to fake the insurance company date? On the report, you can refer to
controls on other objects. So, if you enter 4/20/2004 on the form, you can
display that value on the report, by referring to that control.

i.e. Forms!frmInsuranceReport!txtEndDate

So, the report prints the date entered on the form(which makes the insurance
company happy), and since your data only goes to the 18th, no other problems
arise from the change in criteria.

HTH,