Report expression is combining fields unintentionally

K

KiowaPilot

I have a report and I want to Add two fields together. In the Control Source
field in the properties box of a text box that I drew. I have the expression
=[H]+[W] it is combining the fields as if this expression, =[H] & [W] is
used. Is there something that I missed?

Have
H W H+W
1 0 10
0 2 02
0.2 2 0.22

Want
H W H+W
1 0 1
0 2 2
0.2 2 2.2
 
K

karl dewey

Sounds like one or more are text fields. Check that.
If so, then either change datatype of field or use this --
=Val([H])+Val([W])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top