Type Conversion Error Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am running an access database for a contractor to house some "buyout"
figures. Essentially, a project manager enters the following data into a
form:

ProjectManagerName
JobName
TypeOfMaterial
EstimatedCost
BudgetCost
BuyoutCost

This information shows what the project manager intended to spend
(EstimatedCost) on a particular type of material (TypeOfMaterial,) and what
they ended up paying ("Buyout Cost".) I have two update queries set up to
perform computation on this information after it is entered so that we can
view:

MoneySaved
PercentageSaved

I have the two update queries (one for each mathematical operator) set to
run inside a macro which is controlled by a command button.

The problem is, some entries have information in the "BudgetCost" field, and
some don't. When I try to run the queries on the information, I get a "type
conversion error" for each entry where there is no information for the
BudgetCost field. I want to supress or get rid of this error, because i am
not looking to do math on information that was intentionally left out, so the
query is functioning exactly as intended, just giving me this annoying error.
Thanks for reading, and thanks in advance for your help...
 
Hi Steve,
I think you are having this problem because BudgetCost is sometimes null.
Try creating a new field and use the new field in your calculations instead
of BudgetCost.

newfld:IIF(ISNULL(BudgetCost),0,BudgetCost))
 
Back
Top