Parameter Query Prompts

[HateSpam]

I have a paramter query that wants either of 2 date fields in a table to be before a certain date.

Select * from tblExample where Date1 < [dtCutoff] or Date2 < [dtCutoff]

When I open this query, it prompts me twice for dtCutoff. I've verified I'm using the same spelling and capitalization.

Is there a way to make it only prompt once?

[fredg]

On Sun, 23 Jan 2005 17:06:46 GMT, HateSpam wrote:

I have a paramter query that wants either of 2 date fields in a table to be before a certain date.

Select * from tblExample where Date1 < [dtCutoff] or Date2 < [dtCutoff]

When I open this query, it prompts me twice for dtCutoff. I've verified I'm using the same spelling and capitalization.

Is there a way to make it only prompt once?

As far as I can see, it should only prompt once.
Is the query the record source for a report?
Are you sure the second prompt is from the query, and not from a no
longer used control in the report of which the query is record source?

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Gerhard]

As far as I can tell it should prompt you twice, because you are passing
along two parameters.
Maybe I don't understand the question?

"HateSpam" <Ha******@nospam.com> wrote in message
news:GQ*******************@fe2.columbus.rr.com...

I have a paramter query that wants either of 2 date fields in a table to be
before a certain date.

Select * from tblExample where Date1 < [dtCutoff] or Date2 < [dtCutoff]

When I open this query, it prompts me twice for dtCutoff. I've verified
I'm using the same spelling and capitalization.

Is there a way to make it only prompt once?