Combining Queries

[Owen]

Hi,

I have a 1 table and two queries.

Table 1 has at fields: FCN Number and Error Source
Query 1 has 2 fields : Labor Cost and Equipment Cost
Query 2 has 2 fields: Labor Cost and Equipment Cost

I have two queries because two different cost sources are
paid differently.

Is there a way to combine the two queries in to one query
sorted by FCN Number?

TIA

Owen

 

[Joe Fallon]

Try the key word UNION.

Query1.Sql
UNION
Query2.Sql
ORDER BY FCN