By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,117 Members | 2,142 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,117 IT Pros & Developers. It's quick & easy.

Parameter Query Prompts

P: n/a
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?

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.
Nov 13 '05 #2

P: n/a
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?

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.