Problem adding fields

  • Thread starter Thread starter addproblem
  • Start date Start date
A

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?
 
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)
 
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?


.
Click to expand...

.
Click to expand...
 
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?


.
Click to expand...

.
Click to expand...
 
hello
Van T. Dinh said:
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?


.
Click to expand...
Click to expand...
 
Back
Top