Find out Birthdays

[Fdisk]

I looked through the forum and found similar threads but none that quite answers my question.

I have a table with a birthdate field like 07/08/1973 for example, what I want to do is a simple query that will give me a list of the people whose birthdays are between 7/19 and 8/31 inclusive.

I can't figured out how to say "Where birthdate > 7/19 and birthdate < 8/31" without access adding "2004" to the end.

This is a total newbie question, I'm actually embarrassed to ask, but Google and Access Help have no solved my problem so far :/

Thanks in advance for the help.

 

[raskew]

Hey -

Be not embarrssed. Everyone was a newbie sometime.

Look here
and see if this helps. If not, post back.

Bob

 

[Fdisk]

Thanks!

That thread worked, I guess you are much better at searching than I am

Thank you for the quick reply, this is the best forum I have ever been to!