Union Query Question

E

epete367

I have a table with a field ShipDate. In another table there are fields
ShipDate1 - ShipDate12. I need to create a report that shows shipping
dates broken down by week. I created a union query that unions all
ShipDate fields as DateToShip. Now I need to create the report showing
the other necessary info (OrderID, CustomerID, ShipVia). From trial, I
found I cannot create a report that grabs info from the underlying
queries and the union query. Is there a way to have the union query
show the other columns of info so that the report can be based on that
one query? I am brand new to union queries. Thanks!
 
M

[MVP] S.Clark

The reason, probably, that you're new to Union queries is that, typically,
if you need a Union query, you've done something wrong. Really wrong. For
example, the non-normalized table with the 12 date columns. Any chance you
can normalize that table?

If not, here's my standard workaround answer: Write any report data to a
temp table, then base the report on the temp table, and not the query. Use
append queries to populate the temp table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top