Filter in A report

C

Chris0612

I created a database and from the database I have to pull out birthdays every
month. Therefore, I created a filter on the report. I am new at this so I
wasn't sure if this was correct or not. Needless to say when I filtered the
Oct - Dec birthday's the filter worked correctly. Now when I try to filter
the January birthdays, I get January, October, November and December. All of
the months with 1 associated with it.

My filter is below:
((Birthday.DOB Like "[01]*"))

Can some please help me on the correct filter. I only want the birthdays in
the month of January. I used the DOB short format.
 
D

Douglas J. Steele

Like "[01]*" means return all values that start with either 0 or 1.

Is DOB a date field or a text field?

If it's date, you should be using

Month(Birthday.DOB) = 1

If it's text, you should be using

Birthday.DOB Like "01*"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Month days over a time period 5
Trying to create a report that will list unmatched records by Ticket Primary Key 0
How do I get a month's name to print on a report instead of a #? 1
How to apply the form filter on the report? 3
Filter within a report 4
How to filter a view by birthday OR anniversary this month? 1
Filter in Report 2
Report with disappearing subreports - null values 3

Top