Recent content by ry94080

Looks like this works!!! Thanks @arnelgp ! 🙏

I tried that, but it updates every single record. Which should be the case. It should only update the records that have matching accessions from the vPharmacyAccNo_Finaled query.

Hello, I'm trying to create an update query that contains a join to another query. Usually you get the error, "Operation must use an updateable query." i'm trying to avoid creating a temporary table that contains the contents of the query. I have the query below, but it is not working as...