Hi All
I am so close to a solution that you have helped me towards. I am stuck at a syntax in a query. The following query works fine
SELECT QPostCodeCharges.Charge
FROM QPostCodeCharges
WHERE (((QPostCodeCharges.Courier_Company)=forms!FolCustDN!Cust_Transport_Company) And ((QPostCodeCharges.Service)=forms!FolCustDN!Cust_Delivery_Type) And ((QPostCodeCharges.PostCodePrefix)=forms!FolCustDN!Cust_DelPCode) And ((QPostCodeCharges.PalletNo)=forms!FolCustDN!Cust_Pallets));
But I want it to look compare the first 4 letters in the field forms!FolCustDN!Cust_DelPCode). I tried the following, but it doesnt accept the syntax:
((QPostCodeCharges.PostCodePrefix)=forms!FolCustDN!Left[Cust_DelPCode],4)
Can someone please help?
Thanks
Rob
I am so close to a solution that you have helped me towards. I am stuck at a syntax in a query. The following query works fine
SELECT QPostCodeCharges.Charge
FROM QPostCodeCharges
WHERE (((QPostCodeCharges.Courier_Company)=forms!FolCustDN!Cust_Transport_Company) And ((QPostCodeCharges.Service)=forms!FolCustDN!Cust_Delivery_Type) And ((QPostCodeCharges.PostCodePrefix)=forms!FolCustDN!Cust_DelPCode) And ((QPostCodeCharges.PalletNo)=forms!FolCustDN!Cust_Pallets));
But I want it to look compare the first 4 letters in the field forms!FolCustDN!Cust_DelPCode). I tried the following, but it doesnt accept the syntax:
((QPostCodeCharges.PostCodePrefix)=forms!FolCustDN!Left[Cust_DelPCode],4)
Can someone please help?
Thanks
Rob
