Recent content by squale2

Thanks for all your input. This is not an operating database. I am trying to get this update query to choose the next available record in the table. These records are specific for different types of activities and I would like it to be the next available record. These unique records will...

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 =...