Setting Query parameters

[Guest]

I'm Generating a report from a query that I want to make it easier for the
user. I currently have the following expression typed into the query...

Is null or between [Enter Start Date] and [Enter End Date]

What I really want is...

Any field that is blank or between 1-1-1990 and all records that are one
month away from meeting the date.

What would I type into the query to eliminate the user having to enter dates
each time for the report?

Thanks in advance!
John

 

[Jeff L]

Is Null Or Between #1/1/1990# And DateAdd("m",-1,MeetingDate)
MeetingDate must be a date field for this to work properly

Hope that helps!

 

[Guest]

Thansk Jeff,

I tried the statement, but am getting a message that the statement is too
complicated. Each time I try to run the query, it puts the MeetingDate in "".
I tried to change MeetingDate to my actual box which is Re-Certification
needed, but still get the message. Any thoughts or ideas?

Thanks,
John

Is Null Or Between #1/1/1990# And DateAdd("m",-1,MeetingDate)
MeetingDate must be a date field for this to work properly

Hope that helps!

I'm Generating a report from a query that I want to make it easier for the
user. I currently have the following expression typed into the query...

Is null or between [Enter Start Date] and [Enter End Date]

What I really want is...

Any field that is blank or between 1-1-1990 and all records that are one
month away from meeting the date.

What would I type into the query to eliminate the user having to enter dates
each time for the report?

Thanks in advance!
John

 

[Jeff L]

Put Re-Certification in square brackets []. The statement is probably
being evaluated as Re Minus Certification. It is a good idea to not
use special characters in your field names, including spaces. Letters
and numbers only work best.

Hope that helps!

Thansk Jeff,

I tried the statement, but am getting a message that the statement is too
complicated. Each time I try to run the query, it puts the MeetingDate in "".
I tried to change MeetingDate to my actual box which is Re-Certification
needed, but still get the message. Any thoughts or ideas?

Thanks,
John

Is Null Or Between #1/1/1990# And DateAdd("m",-1,MeetingDate)
MeetingDate must be a date field for this to work properly

Hope that helps!

I'm Generating a report from a query that I want to make it easier for the
user. I currently have the following expression typed into the query...

Is null or between [Enter Start Date] and [Enter End Date]

What I really want is...

Any field that is blank or between 1-1-1990 and all records that are one
month away from meeting the date.

What would I type into the query to eliminate the user having to enter dates
each time for the report?

Thanks in advance!
John

 

[Guest]

This took care of it, thanks Jeff!