Sumation of numbers

[rimo]

Hi everybody. It must be simple answer i guess.

When i sum numbers of fields where information is entered by myself, it is ok.
When i sum numbers of fields where fields where information is formated by IIf function, i always get 0. SQL clauses are ok, problem elsewhere.

 

[Moniker]

That' nice. Is there a question?

(Post your SQL statement, and anything else problem-related.)

 

[neileg]

I agree with Moniker.

I would add that it is easy to turn numbers into text with the format function. Summing text doesn't work...

 

[rimo]

Problem is fixed, it was unknowing such thing as "Update" querry. Thanks