Hi all,
I have two tables, BBB and ScB, and have designed a query to make a new table. In essence the new table just adds a field to BBB from ScB.
The query works ok, with one exception.
Ideally, I would like the field from ScB to be added to the new table only if the value in a field called...