Query for specific month

[bespra]

How do I create a parameter for querying the start date (format is mm/dd/yyyy) so that the user can get a specific month? I tried using [Enter date mm/yyy] but I only get the first day of a month.

[Robeen]

Can you explain in a little more detail what you need to happen?

What do you want your query to display when the user types in 03/2011 - for example?

[June7]

You need to construct a field in query by expression that provides a value that can be filtered.

Format([date field],"mm/yyyy")

Place the input parameter prompt in the criteria for this constructed field.

I don't use input parameter prompts. Can't validate entry. I have users input value in controls on form and refer to the controls as parameters.

[bespra]

We have data input monthly from the 1-30 each month. When they want to review the data for a previous month I need a way for it to filter the master table for only that month with all the data for that month.

[Robeen]

June7's idea is a good one.

Create a new field in your query - like he said:
You can do something like this for your new field:
SearchDate: Format([date field],"mm/yyyy")

Then make your parameter on that SearchDate field.

[bespra]

Thank you, that works great