gpoindexter
New member
- Local time
- Yesterday, 18:59
- Joined
- Apr 29, 2010
- Messages
- 4
I am new to access.
I am trying to write a query that will return the values in column "c" for each of 3 tables when column "a" and column "b" match. Access will only return values when there "a" and "b" appear in all tables. How should I write the query so that it will return the value for "a" and "b" when it does not appear in 1 or 2 of the tables but appears in the third?
I would like the output to be columns to be "a", "b", "c1", "c2", "c3", and if possible "sum c". I need the resulting output to contain all information that was included in the previous 3 tables.
Any help you could provide would be greatly appreciated.
I am trying to write a query that will return the values in column "c" for each of 3 tables when column "a" and column "b" match. Access will only return values when there "a" and "b" appear in all tables. How should I write the query so that it will return the value for "a" and "b" when it does not appear in 1 or 2 of the tables but appears in the third?
I would like the output to be columns to be "a", "b", "c1", "c2", "c3", and if possible "sum c". I need the resulting output to contain all information that was included in the previous 3 tables.
Any help you could provide would be greatly appreciated.