As the title indicates, a tricky query problem.
I have a set of query results that contain two unique criteria that I would like to use in a second query to update a third field.
For ex.
My select query yields among other things a FldA and FldB on each record. These are not unique themselves, but as a combination they will select a unique record (Key!!). I would like to take this set of fields and perform an update on a single table where the records to be updated (updating 'FldC') match the FldA and FldB pairs.
I have seen many examples but none seem to fit my case, or else I don't understand this fully.
Thanks in advance!