Select date range for report

[Guest]

Hello,

I have created a Lease Management database and I'm trying to create a
"remittance" report that will be printed every month for over 100 properties.


This remittance form has to include sales information for the Lease year for
each property (If the lease start date is June 1, 1999, I need to show sales
from June through May of the current year).

I've created a report from a simple query that asks for the payment date,
sales start date, and sales end date. But there has to be a way to
automatically determine this information for each record.

Can anyone help?

Thanks,

 

[Guest]

hi;
i think -if i understood - , you can made it with Form and Query Combination.
First Step;
Create new form (frm_MyForm)
create 2 Textboxes in Form (exp. naned as ; text0 and text2)
control source of Text2;
=CDate(Day(Text0.Value) & "/" & Month(Text0.Value) & "/" & Year(Date()))
if you write 01.06.1999 on Text0 and press Enter; Automatically, Text2.value
comes to 01.06.2007

Second Step;
Create a new query. Add a needed Fields, and criteria for Date;
Between [Forms]![frm_MyForm]![Text0] And [Forms]![frm_MyForm]![Text2]

Last Step;
Create new report base on Query, and add a new button on Form. On Click
Button, run this Report.

if you need an example, please write me

Best Regards;
Özcan ELMALI
(e-mail address removed)