Adding Fields with Text Value 1

[math20]

Hi,

I have a query table that holds value in text data type. What I am trying to do is add these values for each staff. For example: Smith sells Oranges, Apple and Bananas the number is stored as text like 01...

Name Orange Apple Banana Total
Smith 01 02

When I try to use the a query Like

Total: [Orange]+[Apple]+[Banana] the result is blank because there is no data for Orange. My query will work only if I have value for all the field. Like:

Name Orange Apple Banana Total
Smith 01 02 03 6

I hope I am making sense. I would really appreciate any help.

Thank you.

 

[PHV]

Total: Val([Orange] & "")+Val([Apple] & "")+Val([Banana] & "")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[math20]

PHV,

Thank you so much. You are indeed a genius.

Thanks a Lot.