Report help

[Timbo57]

I have a rental database with start date and stop date. i would like to have a form for the user to enter the month and then click a button to run all starts for that month. how can i do this?


Thanks in advance!
Tim

 

[Remou]

Hi
You can run an update query using the date on your form. Is that the kind of thing you were thinking of?

 

[Lilliabeth]

An update query is used to change values in tables, and it sounds to me like you just want to have a button in a form that launches a report that shows records pertinent to the current month.

I apologize if I misunderstand.

Use a query for the record source of the report. THe query should include these 2 calculated fields:

StartMonth:Month([StartDate]) which has the criteria set to Month(Now())

StartYear:Year([StartDate]) which has the criteria set to Year(Now())

Then put a button on your form that launches the report.

I hope this helps.

 

[Lilliabeth]

I just reread your original question and now I see you want the user to ENTER the month, not just use the current month. Sorry. Use a parmeter query as the record source of the report. The criteria for the start date field should be:

Month([StartDate])=[Choose a month from 1-12] And Year([StartDate])=[Choose a year]

 

[Timbo57]

Thanks Lilliabeth, that is just what i was looking for.
Have a great day!