I am trying to come up with 2 queries. I need one to report all of the birthdays of the current month and the other i need to filter out anyone with 8 "points" or greater

Hi

In your query to Filter out anyone with Greater Than 8 points in the crieria row for that Field in your query
you will need to put the following:-

<=8

If you want dates that appear in a specific Month then use the following:-

Between [Enter Start Date] and [Enter Ebd Date]

tyla22,

To return people with a birthday in the current month (using the current date to determine the current month), you'd use a WHERE clause along these lines:

WHERE Month([dteBirthDate])=Month(Date())

To figure out how to filter out anyone with "8 'points' or greater", you'd use:

WHERE [intPoints] < 8

This will display all records where the intPoints field is less than 8.

Hope this helps,

Dennis