I've seen posts on this error before, but none of them helped me solve my problem. Here's my SQL query code:
Code:
SELECT BOMSearch.[BOM Qty], BOMSearch.[BOM UOM], MinPrices.PartNumber, MinPrices.[MinOfUnit Price], MinPrices.MinBuy, MinPrices.MinBuyUOM, MinPrices.[LeadTime(Weeks)], MinPrices.ExpirationDate
FROM MinPrices INNER JOIN BOMSearch ON (MinPrices.PartNumber = BOMSearch.[Part Number]) AND (MinPrices.UOM = BOMSearch.[BOM UOM])
WHERE (((BOMSearch.[BOM Qty])>Qtys.PriceBreakBegin And (BOMSearch.[BOM Qty])<Qtys.PriceBreakEnd) And ((BOMSearch.[BOM UOM])=MinPrices.UOM) And ((MinPrices.PartNumber)=BOMSearch.[Part Number]) And ((MinPrices.ExpirationDate)>=BOMSearch.[DUE DATE]));
The comparison is from a linked excel which has 5 fields which have matching formats to the formats in my table. I suspect it is my ExpirationDate field, which is a calculated field, but is formatted as a Date/Time in the Access table. I just don't know where the error is occurring.
I'd prefer to not delete any fields, as I need all of them.
Ideas?