Enter date once only

[Rob]

I have a query that is based on two other queries, each of these queries has
a Weekending Date field but no criteria entered. The other query that uses
these two queries with Weekending Dates has [Enter Weekend Date:] as its
criteria for both fields. However, both Weekending Dates will always be the
same so unnecessary to force entering twice, is there a way to capture the
date once and pass as the criteria to both fields. I've tried
=(DEBTQuery.Weekending Date) but this doesn't work.

Tahnks, Rob

 

[Duane Hookom]

IMHO, you shouldn't be using parameter prompts
http://www.tek-tips.com/faqs.cfm?fid=6763. If your parameter is in the same
query, you won't be asked twice if it is the same exact parameter.

 

[Rob]

Thanks, the web site was useful and I'm learning more as I read these
forums. Regards, rob

IMHO, you shouldn't be using parameter prompts
http://www.tek-tips.com/faqs.cfm?fid=6763. If your parameter is in the
same
query, you won't be asked twice if it is the same exact parameter.
--
Duane Hookom
Microsoft Access MVP

I have a query that is based on two other queries, each of these queries
has
a Weekending Date field but no criteria entered. The other query that
uses
these two queries with Weekending Dates has [Enter Weekend Date:] as its
criteria for both fields. However, both Weekending Dates will always be
the
same so unnecessary to force entering twice, is there a way to capture
the
date once and pass as the criteria to both fields. I've tried
=(DEBTQuery.Weekending Date) but this doesn't work.

Tahnks, Rob