combinening two query results into one ?

  • Thread starter Thread starter mezzanine1974
  • Start date Start date
M

mezzanine1974

There is a table which has [ACTIVITY_DESCRIPTION], [MATERIAL_PRICE],
[LABOR_PRICE] fields. I created two queries- Query1 sorts
[MATERIAL_PRICE] and Query2 sorts [LABOR_PRICE] in ascending order,
according to a specific common criteria for [DESCRIPTION]. So, Query1
and Query2 produces same number of row for every query.

I would like to combine query results into a single table, so i will
have [MATERIAL_PRICE] and [LABOR_PRICE] in ascending order for a
common criteria of [DESCRIPTION]. My target is to make a chart for
values of material and labor prices in ascending order.

Can I do ?
 
hi,
I would like to combine query results into a single table, so i will
have [MATERIAL_PRICE] and [LABOR_PRICE] in ascending order for a
common criteria of [DESCRIPTION]. My target is to make a chart for
values of material and labor prices in ascending order.
Click to expand...
You have the following two options:

a) Use one query and order by [MATERIAL_PRICE] and [LABOR_PRICE].

b) Create a new union query to combine the results of both queries.
E.g. SELECT * FROM Q1 UNION ALL SELECT * FROM Q2

As far as i understand you, you just need solution a).


mfG
--> stefan <--
 
Back
Top