Combine queries

[thart21]

Getting back into Access after a 2 year absence and can't for the life of me remember how to do this.

I have these tables:
tblForecast - fields GEO, NEED_DT, NEED_QTY
tblPO - fields GEO, NEED_DT, PO_QTY

I want to combine them and end up with these fields in one query
GEO, NEED_DT, NEED_QTY, PO_QTY

Union query doesn't seem to fit this so any help would be appreciated.

Thanks!

[Computer202]

Assuming I have understood correctly here is what you need to do:

[On the ribbon] Create >> Query Design!
Then highlight tblForeCast click add,
Then highlight tblPO click add,
Now you should have them 2 table at the top above the query design...
Now simply double click on each field you require

I am sorry if that was patronising simply making it clear