Date Criteria for a Union Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Should ask once for the entire query, if the parameters are spelled exactly
the same in all the queries. Look for minor typos.
 
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
 
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
 
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])
 
Back
Top