Problem adding fields

[addproblem]

Since installing the 4.0 Jet service pack 8, I can not add
fields together in a query, form or report.

In other words, if I make a control =[A]+and the field
value of [A]=1, and =1, the report of query returns:
11, not 2.

The + returns values like the & does in the query design
view.

Did anyone else have this problem? How do I fix it?

 

[Van T. Dinh]

It sounds to me that your Fields are Text Fields and in
this case, "+" in a concatenation operator rather than the
arithmetic addition operator and therefore:

"1" + "1" = "11"

(you don't see the double-quotes, of course).

HTH
Van T. Dinh
MVP (Access)

 

[addproblem]

First thanks for the reply.

All fields being added are formated as currencies. On
reports made before the update, they are adding properly.
I have even tried copying an unbound control to the new
queries or reports, but I get the same results.

Any thoughts? Could the download be corrupted?

-----Original Message-----
It sounds to me that your Fields are Text Fields and in
this case, "+" in a concatenation operator rather than the
arithmetic addition operator and therefore:

"1" + "1" = "11"

(you don't see the double-quotes, of course).

HTH
Van T. Dinh
MVP (Access)

-----Original Message-----
Since installing the 4.0 Jet service pack 8, I can not add
fields together in a query, form or report.

In other words, if I make a control =[A]+and the field
value of [A]=1, and =1, the report of query returns:
11, not 2.

The + returns values like the & does in the query design
view.

Did anyone else have this problem? How do I fix it?


.

.

 

[addproblem]

Found problem, thanks you were right.

-----Original Message-----
It sounds to me that your Fields are Text Fields and in
this case, "+" in a concatenation operator rather than the
arithmetic addition operator and therefore:

"1" + "1" = "11"

(you don't see the double-quotes, of course).

HTH
Van T. Dinh
MVP (Access)

-----Original Message-----
Since installing the 4.0 Jet service pack 8, I can not add
fields together in a query, form or report.

In other words, if I make a control =[A]+and the field
value of [A]=1, and =1, the report of query returns:
11, not 2.

The + returns values like the & does in the query design
view.

Did anyone else have this problem? How do I fix it?


.

.

 

[wb]

hello

It sounds to me that your Fields are Text Fields and in
this case, "+" in a concatenation operator rather than the
arithmetic addition operator and therefore:

"1" + "1" = "11"

(you don't see the double-quotes, of course).

HTH
Van T. Dinh
MVP (Access)

-----Original Message-----
Since installing the 4.0 Jet service pack 8, I can not add
fields together in a query, form or report.

In other words, if I make a control =[A]+and the field
value of [A]=1, and =1, the report of query returns:
11, not 2.

The + returns values like the & does in the query design
view.

Did anyone else have this problem? How do I fix it?


.