trouble with dates

[cardgunner]

I have a table where I'm recording when I need to follow up with a client. From this table I want to create a query where as the criteria is everything more then 30 days from todays date. I built an expression of Expr1:[date of follow up] - date(). I set the criteria for <30. It gives me everything overdue ( a negative number) and everything going to be due in 30 days or less. However if I take the 30 out and substitute a parameter"[How Many Days]". It only gives me the positive numbers. Why is that and what can I do? I would like to take this query and build a report off of it where as when I open the report i will have to answer that question and it will give me everything overdue plus what will be due.

 

[gromit]

Not positive if this is your problem, but give it a try -

Explicitly declare your parameters using the Query / Parameters menu item (while in design view). Make sure you set [How Many Days] to Integer or Long.

(I suspect what may be happening is that Access is evaluating [How Many Days] as a string parameter.)

hth,

- g

 

[cardgunner]

Thank you very much. I did just that and it works just fine.

 

[gromit]

Great! Glad that it helped.