Solved Query two tables with different field header Name..

[Number11]

I am tying to find a way on how I can create a query from two tables and combine the results the fields are

Table name: Model_Elec
Field names: Postcode (text)
Field names: CustomerID (number)
and
Table named:Model_Elec1
Field names: Postcode (text)
Field Names:CustomerAC (number)

 

[Minty]

You can't have the table in the same database with the same name?
So the example given isn't correct or you haven't given us the whole story...

 

[Number11]

You can't have the table in the same database with the same name?
So the example given isn't correct or you haven't given us the whole story...

it doesnt have the same name one is called "Model_Elec" and the second is called "Model_Elec1"

 

[G37Sam]

Something like this?

SELECT Postcode, CustomerID FROM Model_Elec
UNION
SELECT Postcode, CustomerAC FROM Model_Elec1

 

[Minty]

Okay - so after the edit - you can do the following

SELECT Postcode, CustomerID
From Model_Elec
Union
SELECT Postcode, CustomerAC
From Model_Elec1