Specific Month from Date

[John]

I have a query that has a transaction date in it with 4
other fields. With the date I want to be able to sort by
month. I would like to be able to use the query
parameters so the user can enter the month. I can't get
this to work at all.
I have 4 months of data and when the user runs the query
they are prompted to enter a month and the query will
extra the records for that month.

Please help!

TIA,

John Daily

 

[kevin]

Tia,

Look at the date info in help. I had the same type of
problem. It is an issue of proper syntax in the query
parameters. You need to invoke a dialog box for the user
and they just then need to put in a number that
corresponds to the month portion of the date field.

The help in access has some good examples of how to get
the right syntax to query just that info.

Kevin

 

[Fredg]

John,
Several ways to do this.
Simplest is to add another column to your query:
Exp:Month([DateField])

As criteria for this column, write:
[Enter month number]

When prompted, enter a number 1 through 12.

 

[john]

Thank you Fred & Kevin