How can I create a parameter query that lets me just specify a month period, i.e. July?
If you have a date in a query and you just want to return items within a certain month set up as a parameter query, there is more than one way to do it, but probably the easiest from the point of view of the person running the query is first to create a new field giving the monthname.
E.g. MonthIn: MonthName(Month([DateIn]))
Then in the criteria row under your new field, type something like [What month?]. This will allow people to type in the month required, e.g. July to return the required data.
Find out more about our Microsoft Access training courses Sydney, Australia.
Find out more about our Microsoft Access training courses London, UK.