I have two reports. They are working great except for one minor problem. I only want them to pull activity for a particular month, and I want to be able to put in the month I want. We currently have form set up where dates can be entered and information is pulled only for the dates entered; however, I do not know how to link my reports to this form or set up a similar form. I have no access training. What I know is all through experience. I have built tables, reports and queries. Does anyone have any suggestions or ideas?

Here is one way to do it.....Create a form with a text field on it. Call the field FindMonth, or anything you like, and do the same for the form name.

Create a query and put all of the fields that you want displayed into the QBE grid. In an empty column put this in the top field- Selected Month: Month([Dates]). The 'Dates' is the field from your table that contains the month(s) that you are looking for. In the Criteria row of the column Selected Month put this- Month([Forms]![NameOfFormYouJustMade]![FindMonth]).

Create your Report using the query as the Record Source. Created a command button on the form with the Wizard that will open the report that you just make.

To see your report open the form and in the FindMonth field put Mar, 2000 or any viable month with the year. Click the command button to show your report and you should see your records for the month selected....

If this is not clear to you drop me an email and I will send you a small demo....