DatePart in Parameter Query

[pjscott]

I have a parameter query that queries the month and on a day of the month
range. I’m using the following in the query:

WHERE (((DatePart("m",[Doh]))=[Enter a Month]) AND ((DatePart("d",[Doh]))
Between [Enter a start day] And [Enter an ending day])

When I run the query and choose a day between 1 and 15 only days with a 1
display. In other words days between 2 and 9 do not display.

What am I doing wrong?

Thanks,

Paul

 

[Ofer Cohen]

That usually happen when the condition is on a text value, so 2 is actually
higher then 15

Try:
WHERE DatePart("m",[Doh])=[Enter a Month]) AND Val(DatePart("d",[Doh]))
Between Val([Enter a start day]) And Val([Enter an ending day])

Turning the text into number

 

[pjscott]

I got an error when I tried to use the val(DatePart("d",[Doh])).

I did get it to run fine by just using the val in the Between statement.

Thanks Ofer for the help and have a good day.

That usually happen when the condition is on a text value, so 2 is actually
higher then 15

Try:
WHERE DatePart("m",[Doh])=[Enter a Month]) AND Val(DatePart("d",[Doh]))
Between Val([Enter a start day]) And Val([Enter an ending day])

Turning the text into number

--
Good Luck
BS"D

I have a parameter query that queries the month and on a day of the month
range. I’m using the following in the query:

WHERE (((DatePart("m",[Doh]))=[Enter a Month]) AND ((DatePart("d",[Doh]))
Between [Enter a start day] And [Enter an ending day])

When I run the query and choose a day between 1 and 15 only days with a 1
display. In other words days between 2 and 9 do not display.

What am I doing wrong?

Thanks,

Paul