combining two queries

[RogueUK]

I seem to have a problem combining two queries, I only seem to have a limited amount of search criteria I can use.
How can I add two queries and have one single out put?
These are the two queries

SELECT [location codes].[Location Code], [location codes].[ID], [location codes].[Loc Name], [location codes].[Address 1], [location codes].[Post Code]
FROM [location codes]
WHERE ((([location codes].[Location Code])="A0012")) OR ((([location codes].[Location Code])="A0039")) OR ((([location codes].[Location Code])="A0065")) OR ((([location codes].[Location Code])="A0073")) OR ((([location codes].[Location Code])="A0071")) OR ((([location codes].[Location Code])="A0070")) OR ((([location codes].[Location Code])="A0079")) OR ((([location codes].[Location Code])="A0078")) OR ((([location codes].[Location Code])="A0104"));


SELECT [location codes].[Location Code], [location codes].ID, [location codes].[Loc Name], [location codes].[Address 1], [location codes].[Post Code]
FROM [location codes]
WHERE ((([location codes].[Location Code])="B8681" Or ([location codes].[Location Code])="B5517" Or ([location codes].[Location Code])="B5516" Or ([location codes].[Location Code])="B2353" Or ([location codes].[Location Code])="B1905" Or ([location codes].[Location Code])="B1882" Or ([location codes].[Location Code])="A0104"));

 

[anvil19]

Hi RogueUK

You can create a UNION query. It is only available in Access, and as long as your headings for both SELECT statements are the same you just add the UNION clause between the SELECT's like so:

SELECT [location codes].[Location Code], [location codes].[ID], [location codes].[Loc Name], [location codes].[Address 1], [location codes].[Post Code] 
FROM [location codes] 
WHERE ((([location codes].[Location Code])="A0012")) OR ((([location codes].[Location Code])="A0039")) OR ((([location codes].[Location Code])="A0065")) OR ((([location codes].[Location Code])="A0073")) OR ((([location codes].[Location Code])="A0071")) OR ((([location codes].[Location Code])="A0070")) OR ((([location codes].[Location Code])="A0079")) OR ((([location codes].[Location Code])="A0078")) OR ((([location codes].[Location Code])="A0104")); 
UNION
SELECT [location codes].[Location Code], [location codes].ID, [location codes].[Loc Name], [location codes].[Address 1], [location codes].[Post Code] 
FROM [location codes] 
WHERE ((([location codes].[Location Code])="B8681" Or ([location codes].[Location Code])="B5517" Or ([location codes].[Location Code])="B5516" Or ([location codes].[Location Code])="B2353" Or ([location codes].[Location Code])="B1905" Or ([location codes].[Location Code])="B1882" Or ([location codes].[Location Code])="A0104"));

Try that

anvil19