Good Morning,
I am new to Access and trying to complete the following task, I have a database that has a select query that pulls the following 3 columns, customer ID, Sequence number, shipping number. I want to be able to tie it into the main query that lists out all customer information in which it will be tied in a similar manner to the below.
Customer number is linked to customer number in main table, and I want if sequence number =1 then copy shipping number to field "UPS" in main table, if sequence number =2 then copy shipping number to field FedEx, etc.
Does that make sense? I can see the information that I want but I am unsure how to get it to map to the correct customer
Any help is greatly appreciated and I apologize if I did not use the correct terminology.
Thanks in Advance!
Brent