Calculations in a query !!

[zacharyjunior]

Ii have a query that shows the cost associated with a customer complaint. The fields in the query are:

Complaint Date

Complaint ID (AutoNumber)

Invoice: Nz([tblInvoices]![Parts]+[tblInvoices]![Labor]+[tblInvoices]![Misc],0)

Parts: Nz([tblOrderDetails]![StandardCost]*[tblOrderDetails]![Quantity],0)

When I try to add both of the above expressions it does not work. Here is what I had as a expression to total both.

[Invoice]+[Parts]

The expression gives me a number but it is not adding the fields together as a total. It gives me the two numbers mashed togther. For example. 25+10 It gives me 2510.

Any thoughts?

 

[jwindon]

It appears that those two fields are stored as text versus numbers.

Try this:

Total: Val([Field3])+Val([Field4])

[This message has been edited by jwindon (edited 01-21-2002).]