The table I want to run the query on has a date in the format of dd/mm/yyyy. I want to be able to run a query so that the user can type in a month and all records with dates in that month will be shown.

I have done this before many years ago but now have a mental block and cant figure it out.

Any help with this would be greatly appreciated

How will the user type in the month? I think you should give them a combo with two columns. Column(0) = 1 - 12, and Column(1) = "January" - "December"

Allow them to select a month, and then add a column in the report called "SelMonth" (for selected month) that is:

SelMonth:(DatePart("m", [DateColumnName]))

Then in the criteria line add this:

Criteria: [Forms]![frmYourFormName].[cboDateSelectComboName]

When the query opens, it will select the records with a Month with the selected numeric value. You don't have to display the SelMonth column in your results.

That is one way of doing it. With information on buttons to launch the query, or reports or forms to display the query results, I could post other methods.

In this case, Date format won't matter unless this is not a Date column, but a text column. If it is a text column, then you have other issues.

Did that help?

mmcdonal