Date Criteria for a Union Query

R

Ryan W

I have a several queries that I am bringing together in a Union. Each query
has a date parameter. For each query I have set the parameters for Date/Time.
In my SQL I have designated start date/end date as date/time as well. When I
run my Union, it asks me over and over again for the date parameters. Is
there a way that I can only have it ask once?

Thank you in advance, Ryan
 
K

Ken Snell [MVP]

Should ask once for the entire query, if the parameters are spelled exactly
the same in all the queries. Look for minor typos.
 
R

Ryan W

Ken,
Yes....those minor typos.....I got it worked.

Another question, In my queries before the union I made the properties on
one field to be currency. That property does not cross over in the union. Is
there a way that I can get it to cross over?

Ryan
 
T

Tom Ellison

Dear Ryan:

I recommend you perform the union in a saved query that doesn't prompt
for your start / end dates. Create another query based on the saved
union query that prompts for your dates.

There may be simple causes for your problem, but this is a sure
solution.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
K

Ken Snell [MVP]

Formatting of data often is "lost" by queries depending upon what the query
is doing. To force a currency format, use a calculated field in the query in
place of the original field, and use an expression that wraps the field with
the CCur function:

CurField: CCur([FieldName])
 
Top