Combining results from 2 queries. 1

[maxxev]

Hi, as a Novice in access could someone help me to combine 2 queries.

Basically I have 2 queries:

"QAllergens in spec (components)"
"QAllergens in spec (subcomponents)"

They both contain identicle results in 2 fields:
"Ing_specID"
"Allergen Type"

I would like a third query that can simply list both results in the one list, is this possible?, and if so how do I do it.

Thank you.

 

[Remou]

Do you mean:

SELECT Ing_specID,[Allergen Type] FROM [QAllergens in spec (components)]
UNION
SELECT Ing_specID,[Allergen Type] FROM [QAllergens in spec (subcomponents)]

 

[maxxev]

Hi, thank you for reply.

I'm afraid I have no idea where to put that code....?

 

[maxxev]

Think I got it. Thank you.

 

[Remou]

It is SQL. Paste it into a query design window in SQL View. It may not work, it depends whether or not you have reported the names exactly and whether or not I understood what you reported.

 

[maxxev]

It works great thank you

 

[dhookom]

A "works great" answer deserves a star ;-)

Duane
Hook'D on Access
MS Access MVP

 

[Remou]