DLookUp in Queries
Posted on 2013-06-24
I need a combo box to compare the current forms control values with values that are available from a standards table.
Pricing picture Frames. A manufacturer wants an easy way to consistently price custom size frames. He has prices in a table (Standards) based on height and width of frame which he buys from different suppliers. In the combobox's query how do I find the nearest size specified on the main form to that available from stock, only showing the closest size large enough from each supplier.
So I want to price a frame that is 95mm by 155mm from my Standars table which has:
Supplier Smith, nearest size 100 x 160
Supplier Jones, nearest size 95 x 170
Both Smith and Jones have multiple sizes available in my Standards Table.
What I can do is use a DLookUp for the sizes but I am told that you should not use DLookUp in queries?