MS Access Question

[UnworthyBean]

A quick and hopefully simple question, If I have a field which has a format of DD/MM/YYYY MM:SS is there anyway to setup a form to type in 'March' and it will find all entries within march?

Currently, I have to type in **/03/** which is a bit of a pain.

 

[Participant]

At a guess you'd need to set up a lookup table then have the form return the column two result from a column one drop down list. Sorry I can't be more helpful or specific, there don't seem to be many Access gurus on this forum either so maybe you could ask on a specialist forum if no-one knowledgeable shows up soon.