468,284 Members | 1,625 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,284 developers. It's quick & easy.

Parameter Query Prompts

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
2 1426
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
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.

Similar topics

5 posts views Thread by MX1 | last post: by
1 post views Thread by Gogo | last post: by
reply views Thread by NPC403 | last post: by
2 posts views Thread by MrBee | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.