Empty Column in Query

[sesproul]

Hello,

I am trying to create a UNION statement using two queries Query1, and Query2. Query1 has an additional Column, ConcreteYards. it is created from a previous Grouped query that includes additional data from a table with that data.

How do I modify the Query2 to include an empty column that will allow me to union the two queries.


thanks



Steve

query1
--------
Name
SumHrs
date
ConcreteYards

query2
--------
Name
SumHrs
date

[RuralGuy]

SELECT "ThisText",
...would reserve a position in that query.

[sesproul]

Thanks for the help

[RuralGuy]

You're welcome. Are you ready to follow the link in my sig and mark this thread as Solved?