enter number for month

[slimjen]

All, using Access 2010. I have a form for users to enter data on a monthly basis. The form is based on a query. When the User pulls up information for that particular user they’re asked to enter their name then month (1/1/2016) to pull up data pertaining to that particular month. Is there any way they can enter just the number of the month they want and pull up the same data for that month? I can’t remember whether I have to have a table with the number of the months listed which I don’t really want. Just thinking of short cuts. Thanks.

[June7]

Certainly - more than one way.

1. dynamic parameterized query

2. VBA to construct filter criteria, review http://www.allenbrowne.com/ser-62.html


Do you want to offer user option to select a year?

[slimjen]

No Just the month number. I want to be able to use it in the query. Should I search dynamic parameterized query??