Hi, I ask this question before but perhaps I did not explain myself properly. I have a table with the following fields: Name,Addres1,Address2,IsBillto, etc. Now my records show
Name: Computer
Address1: 81 appletree st.
Address2: Suite # 81
IsBillto: Yes
Name: Computer
Address1: 90 Appletree st.
Address2: Suite # 5
IsBillto: No
As you can see I have 2 records with the same name and 2 different address (Only because this customer have a bill to and a ship to. If a customer only have a bill to, I will have only one record). What I want to do is create a query that will pull only one record per customer showing only ship's to addresses (if both exist) and to pull the bill to addresses for those who do not have a ship to address............. Can anybody help me to figure this out, please?
Name: Computer
Address1: 81 appletree st.
Address2: Suite # 81
IsBillto: Yes
Name: Computer
Address1: 90 Appletree st.
Address2: Suite # 5
IsBillto: No
As you can see I have 2 records with the same name and 2 different address (Only because this customer have a bill to and a ship to. If a customer only have a bill to, I will have only one record). What I want to do is create a query that will pull only one record per customer showing only ship's to addresses (if both exist) and to pull the bill to addresses for those who do not have a ship to address............. Can anybody help me to figure this out, please?
