I have created a Dlookup condition in a Query as below which has issues
DLookUp("uncoatedrate","tblfabricconvrates", "tblpricingitemmaster.uncoatedgsm BETWEEN "tblfabricconvrates.GSMmin" AND "tblfabricconvrates.GSMMax"" AND "tblcustrfq.endcustomer = ' tblfabricconvrate.custID')
Never constructed something with so many conditions
The Query has tblpricingitemmaster where there is field "uncoatedGSM'
In this Query, there is relationship between tblcustrfq.erpfgcode and tblpricingitemmaster.erpfgcode
For the given erpfgcode in the tblcustrfq we need to look for a value Uncoatedrate in "tblfabricconvrates" such that the uncoated GSM of tblpricingitemmaster falls between GSMMin and GSMMax of tblpricingitemmaster
There is another condition which needs to be matched. The tblcustrfq.endcustomer = custid field in tblfabricconvrate
The DB is enclosed. Qry name is qryquotecaculation
DLookUp("uncoatedrate","tblfabricconvrates", "tblpricingitemmaster.uncoatedgsm BETWEEN "tblfabricconvrates.GSMmin" AND "tblfabricconvrates.GSMMax"" AND "tblcustrfq.endcustomer = ' tblfabricconvrate.custID')
Never constructed something with so many conditions
The Query has tblpricingitemmaster where there is field "uncoatedGSM'
In this Query, there is relationship between tblcustrfq.erpfgcode and tblpricingitemmaster.erpfgcode
For the given erpfgcode in the tblcustrfq we need to look for a value Uncoatedrate in "tblfabricconvrates" such that the uncoated GSM of tblpricingitemmaster falls between GSMMin and GSMMax of tblpricingitemmaster
There is another condition which needs to be matched. The tblcustrfq.endcustomer = custid field in tblfabricconvrate
The DB is enclosed. Qry name is qryquotecaculation