Updating a query in ms access
or create a form with a button the executes the above routine.
I should of added, I have a little SQL knowledge and a little Microsoft Access knowledge and zero knowledge about things like creating procedures etc.
When I run the query it states it's going to update the records and if I'm sure I want to update, I click yes but then when I check the T_Final test table it hasn't updated the missing UPNs.
I'm at a loss to how to get the query to run so that it will update the missing UPN's in the T_Final test. In the designgrid it should look like this: Field: Your tablefield with missing data Table: Your table Update To: Datasource so Field: UPN Table: T_Finaltest Update to: T_Pupils.
If "nothing came back" then you are clearly not looking in the correct place.Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.You'll be able to ask any tech support questions, or chat with the community and help others.If you can't see anything wrong with it, post the string in here.Your first step should always be to print off the string you're intending to pass to the SQL engine and see if that still makes sense.