IT Employment

Ask something
Discussion Locked

Access 2000

0 helpful
3 replies

by layland

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have build a table with standard information. Within that table I have a Birthday column. Formatting is 00/00/0000.
I have build a query to pull up the current month's birthday's. I have the query to ask me what month I would like. When I type in03 or 10 the query will not being up anything. Why? Is it looking for more? Any help would be grateful!
Thanks for you time.

3 replies

by mbarker734

In a blank field area of your query type:

[Enter the Birthday Month 1 to 12]

or what ever else you want between the brackets. I suggest you indicate 1 to 12 as this will not work with 01, 02 etc.

Then in the criteria area enter the following:

Month([tablenamewithbirthdate]![Birthdatefieldname])

place the appropriate names in the bracketed areas. The function Month return the month number of a date formated field.

This discussion is closed to new replies.