Appending 2 tables

D

Dennis H

I start with tables x and y. Link DIST and OBS1
I get query1 with a select query.
I want to get Query WANTED.
I've tried NOT linking.

TABLE x
DIST OBS1 X CountOfSEG
3 09 1 62
3 09 1 63
3 09 1 69

TABLE Y
DIST OBS1 X CountOfSEG
3 09 2 7
3 09 2 81

Query1
DIST OBS1 X X.CountOfSEG Y.CountOfSEG
3 09 1 62 7
3 09 1 62 81
3 09 1 63 7
3 09 1 63 81
3 09 1 69 7
3 09 1 69 81

Query WANTED
DIST OBS1 X X.CountOfSEG
3 09 1 62
3 09 1 62
3 09 1 63
3 09 2 7
3 09 2 81
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

select query - Appending 2 tables 1
Section and Page numbering 0
Need some PWA help 0
List all tables, including document structure 0
Complex Count Query 0
horizontal & vertical on same report?? 2
Total by certain time period 1
Formula in Access Query to genrate numbers 1

Top