I am trying to run an update query but when it pulls the data from the REPORT# table it is not the first available record. Is there a way in an update query to tell it to choose the min number? Here is what the query looks like:
UPDATE [User Data] INNER JOIN [REPORT#] ON [User Data].TYPE =...
