Query for finding matching months?

[TYLER_DURDEN]

I want to create a query that finds the matching month, for example I type in jun or mar, and it finds all the records that match that?

TDS

 

[Cosmos75]

Month Combobox

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=44399

You can create a table (tblMonth) with two fields
MonthID (Number, NOT Autonumber - PRIMARY KEY), Month (Text)
1, Jan
2, Feb
...
12, Dec

Then create a combobox (cboMonth) that shows values from the table (Hiding the primary key column).

Then in your criteria (see above link to your other thread), have it reference the combobox. It will then use the primary key as criteria. So if you've entered the Month and MonthID correctly, the user will see the name of the month. The combobox will work in replacing the textbox where the user enters the number for the month.


Hope this helps!

 

[KevinM]

OR...

Create a column in your query with this expression..

MonthDate:Format([MyDate],"mmm")

and add [Enter Date e.g Jan, Feb] in the criteria.
This will be your Paramater