I am doing a join from 2 tables and have a weird sort of thing happening. The 2
fields I am comparing are a "Numeric" fields. If one of the fields has a 2
digit number my query doesn't work. If it has a 3 digit number it works fine??
Here is the query.

SELECT Freight, Taxes, ULMargin, Clm10, Clm1, Clm8, Clm9,
Freight+Taxes+ULMargin+Clm10 AS TotalPrice
FROM Customers, FuelData
WHERE ClmID = UnleadedRef AND Customers.ID = MMColParam