Sum in Row Source of Rpt

[Guest]

I have a qry using Count function so that my qry results in just one record
displaying the total records fitting the criteria specified. I then want to
use that query to generate a report (graph). I am trying to add a couple of
the fields together to get a total "other".

her is my Row Source: SELECT [CountOfQIID],Sum([CountOfQIID]) AS
[Total],Sum([EmpOther]+[EmpPropDamage]+[EmpTheft]+[EmpPolicy])AS[Other] FROM
[qryEmployee] GROUP BY [CountofQIID];

Instead of adding 3 + 0 + 0 + 0 + 0 to equal 6, my total [Other] comes out
to 3000.

Also, when formatting a graph, is there any way to "Wrap" the format axis
titles if they are too long.

THANK YOU

 

[Guest]

The total I am expecting is 3 (not 6), am getting 3000.

Anyone out there that can HELP!?

 

[John Spencer]

For some reason, + is treating the values in the fields as if they were
strings. Something in QryEmployee is probably causing this to happen.

Try forcing the data type with CLng or the Val function.

SUM(CLng([EmpOther]) + CLng(EmpPropDamage) + CLng(EmpTheft) +
CLng(EmpPolicy)) as [Other]