Union Query Question

[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!

 

[[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.