Recent content by LisaC31

Ok great! Thanks Arnel!! It looks like the Part Id field did have extra spaces in addition to an extra space in a couple of other fields in the source table. I may update the field names to the proper naming convention but needed a quick fix to work with for now. Thanks again, much appreciated!

Thanks so much Arnel. When I tried to run, I ended up getting an 'Enter Parameter Value' for ZQM88 Qlik Tbl.Field Name when trying to run the entire query. I tried to isolate it and run it for one field and it updates fine. When I include all the fields, I'll get the Enter Parameter Value...

Hi Pat Hartman, Can you explain the "t." and "s." before the Cust Originator Id in your sample? Is it read as If SAP Masterview.Customer Originator Id is null, then ZQM88 Qlik Tbl.Customer Originator Id, Else SAP Masterview.Customer Originator Id? I don't mind typing or doing a lot copying...

isladogs, When you say create a procedure do you mean VBA or is this something that can be done in Access SQL?

Ha! Great, I feel welcomed!

Hello! Just a heads up, I'm not skilled in SQL but I am familiar with creating queries in Design View of Access. The problem I'm having is that I need to update an existing Access table (SAP Masterview) with corresponding fields from a linked Excel table (ZQM88 Qlik Tbl). I only want to...

Hello! My name is Lisa and I live in Michigan (USA:). I am here to obtain help as I don't think I'm skilled enough to offer much help :) By the way, my mom/mum is a British citizen!