Help for query

[Guest]

I have two tables:

Table A
Key1 Key2
==============
A1 B1
A1 B2
A2 B3


Table B
Key1 Key2
==============
A1 C1
A2 C2
A2 C3

I would like to have query to come up following:

Field1 Field2 Field3
=================
A1 B1 C1
B2
A2 B3 C2
C3


Is this possible by sing query?
TIA

 

[Guest]

You can't hide the fields, but you can create a query that return all the
records

SELECT TableA.Key1, TableA.Key2, TableB.Key2
FROM TableB INNER JOIN TableA ON TableB.Key1 = TableA.Key1
GROUP BY TableA.Key1, TableA.Key2, TableB.Key2;

And then base a Report on this query, set the Hide duplicate property of the
text boxes to Yes, that way the fields won't be shown