Finding values in a table

[Mike20255]

I have narrowed it down further:

Expr1: Format(Sum([city wide]+[pol]+[urban f]+[rural f]+[urban t]+[rural t]+[para t]+[education$]+[fir s]),"Currency")

Whatever is the second to be added in this formula can't be formatted, so in this example if I format [pol] to currency the formula won't work but if I leave it as non-formatted it will work fine, doesn't matter what I do it always get stuck on the second one if it is formatted?

 

[boblarson]

I have narrowed it down further:

Expr1: Format(Sum([city wide]+[pol]+[urban f]+[rural f]+[urban t]+[rural t]+[para t]+[education$]+[fir s]),"Currency")

Whatever is the second to be added in this formula can't be formatted, so in this example if I format [pol] to currency the formula won't work but if I leave it as non-formatted it will work fine, doesn't matter what I do it always get stuck on the second one if it is formatted?

How about not formatting the query column and format it in the form or report? (users shouldn't be directly accessing queries and tables anyway, so if you have the value available to a form or report it should be able to be formatted at that time.

 

[Mike20255]

How about not formatting the query column and format it in the form or report? (users shouldn't be directly accessing queries and tables anyway, so if you have the value available to a form or report it should be able to be formatted at that time.

Ya I will have to do it this way. It is irritating that I couldn't figure it out in the query though

Thanks very much for your help!