I want to create a query using DLookup.
I've tried so many combinations in writing a query but I keep getting errors
due to synax. I'm ready to quit but I know it's something simple.
Could someone help me?
I'm trying to create a make table query using DLookup.
I want to extract the UNIT_PRICE and REPAIR_PRICE from TABLE2 were the DATE_ORD in TABLE1
falls between the DATE_BEGIN and DATE_END of TABLE2.