This date thing is driving me crazy!!!

[Noreene Patrick]

I have a report that needs to query by date, but I need to use an input box when report opens to enter date and then I only need it to return dates using month and year.

Such as:
When report opens I want to put in the input box this date, 04/04, and it returns all employees whose license expires in April, 2004. I cant figure out how to do this. (If I could make my table accept only month/year then it might be easier to query. But my table will display as mm/yy but it makes me put in entire mm/dd/yy.)

I am not sure how to make my input box connect to the query. You see, I need much help....

Could someone send me off on the correct path?

Thanks in advance

 

[Valerie]

I would create a form with two visible fields: One containing a combo with the Month names and the other asking for the year.

I would then also have two hidden fields (visible = no) which contain calculations: one for the 1st of the month and one for the last of the month. I would then refer to these two hidden fields in the criteria of the query.

Rather than running the report, open this form and have a command button on it which previews the report.

 

[Noreene Patrick]

Thanks, Valerie

I will try this. I have another project that has come up today, but as soon as I can, I will work on this one.

Thanks again!!