Hi new here, registered as this problem will drive me mad if I dont get help - I'm sure it must be possible...
I've not got much experience with Access or any other sort of SQL.
I have tableA and tableB. tableA contains Col1 and Col2 (Concatenated PK). tableB contains Col1, Col2 and Col3 (PK). tableB Col1 lists distinct values from tableA Col1 - no problems. I want tableB Col2 to list distinct values from tableA Col2 where Col1 in tableA and tableB match. So that is a query with two variables. Please don't be distracted by DISTINCT - this is not the problem!
All the examples on the net I've seen of SELECT WHERE queries show something like WHERE variable = constant, so I don't even know if what I am trying to do is possible, never mind the details of it.
Please Help![]()