Access 2007 and Dates

F

Fev

Hi
I am using a parameter query combined with Dateformat to list upcoming
birthdays. I have used this technique in previous versions of Access
97 - 2003, without a problem. However in Access 2007 I keep getting
inconsistent results. Here are my parameter queries and results:
Between [Enter Start Day Number] And [Enter EndDay Number]
Field Expression: DatePart("d",[DateOfBirth])

[Enter Month as a number eg 03 for March]
Field Expression: DatePart("m",[DateOfBirth])

When I enter the following: Day nos 1 and 9 and month 1 I get:
Birthday
01 January
07 January

However when I enter the following: Day nos 1 and 10 and month 1 I
get:
Birthday
01 January

I do not get 07 Jan birthday. It appears to be affected by leading
0's.
Can anyone help me with an explanation?
Thanks
Heather
 

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

Access 2007 and Dates 1
selecting month 3
How do I get a month's name to print on a report instead of a #? 1
Query Problem 4
Dlookup 7
Using function to get previous month 5
Sorting by Month and Year in Query 2
Report with disappearing subreports - null values 3

Top