Field format

[Guest]

I have done a Cross tab Q that Gives me the data that I need to start a form.
On the cross tab I have the Val as 0 if the field is null. This works GREAT.
But I still need to do some math on the form. But when I do this =[Field 1] +
[Field 2] and it just puts the fields together. Ie 5+1 is now 51 not 6. I
have gone into the cross tab and put the format for this field a General
Number and it still does not work.
Thanks

Code:
TRANSFORM Val(Nz(Count(DEPInDate),0)) AS [The Value]
SELECT [DEPInGrossNumbersFYLookUp Q].RC, [DEPInGrossNumbersFYLookUp Q].[RCTR
Last 4], Count([DEPInGrossNumbersFYLookUp Q].DEPInDate) AS [Total Of
DEPInDate]
FROM [DEPInGrossNumbersFYLookUp Q]
GROUP BY [DEPInGrossNumbersFYLookUp Q].RC, [DEPInGrossNumbersFYLookUp
Q].[RCTR Last 4]
PIVOT [DEPInGrossNumbersFYLookUp Q].MissionCAT In
("GMA","GMB","GM4","GM5","GFA","GFB","GF4","GF5","SMA","SMB","SM4","SM5","SFA","SFB","SF4","SF5","HMA","HMB","HM4","HM5","HFA","HFB","HF4","HF5","CMA","CMB","CM4","CM5","CFA","CFB","CF4","CF5","PS","NMA","NFA","NMB","NFB","NM4","NF4","NM5","NF5");

 

[Allen Browne]

JET regularly misunderstands the data type of calculated fields.

Explicitly typecast each field you refer to the the Control Source of your
text box, e.g.:
=CDbl(Nz([Field1],0)) + CDbl(Nz([Field2],0))

More info:
Calculated fields misinterpreted
at:
http://members.iinet.net.au/~allenbrowne/ser-45.html