C
Carl Jarvis
I have 2 tables where I am looking to identify common items and also
different items. I am doing quite well for a complete novice, but have hit
a brick wall, I wonder if anyone can help.
I have 2 queries which share some common answers, they also have some unique
answers. For example.
Query 1 Query 2
Field A 1 1
Field B 2
Field C 3 3
Field D 4
Field E
The most I can match in query 1 or 2 is 3 out of 5 records, however if I
merge them I could match 4 out of 5? Any ideas how I would go about this?
Many thanks to those who reply!
Carl.
different items. I am doing quite well for a complete novice, but have hit
a brick wall, I wonder if anyone can help.
I have 2 queries which share some common answers, they also have some unique
answers. For example.
Query 1 Query 2
Field A 1 1
Field B 2
Field C 3 3
Field D 4
Field E
The most I can match in query 1 or 2 is 3 out of 5 records, however if I
merge them I could match 4 out of 5? Any ideas how I would go about this?
Many thanks to those who reply!
Carl.