Summation in report

[Guest]

I am trying to do a sumation field in a report, but instead of summing the
fields I specify, it is concatenating them. I do use the formatcurrency
function in some earlier queries on this field, so I am thinking that is
causing a problem. I even tried summing them in the actual query and it did
the same thing. Thanks for any help.

 

[Guest]

Please show the formula.

 

[Guest]

This is the formula in my control source
=[Jan Draw]+[Feb Draw]+[Mar Draw]

 

[Guest]

What are the data types of these fields? If the are text then you may have
to do something like Cdbl([Jan Draw]) +Cdbl([Feb Draw])+Cdbl([Mar Draw]) or
what suits you better (Cint, Ccur,..).

This is the formula in my control source
=[Jan Draw]+[Feb Draw]+[Mar Draw]

Please show the formula.

 

[Guest]

I used Ccur and it worked. Thanks for your help!

What are the data types of these fields? If the are text then you may have
to do something like Cdbl([Jan Draw]) +Cdbl([Feb Draw])+Cdbl([Mar Draw]) or
what suits you better (Cint, Ccur,..).

This is the formula in my control source
=[Jan Draw]+[Feb Draw]+[Mar Draw]

Please show the formula.

:

I am trying to do a sumation field in a report, but instead of summing the
fields I specify, it is concatenating them. I do use the formatcurrency
function in some earlier queries on this field, so I am thinking that is
causing a problem. I even tried summing them in the actual query and it did
the same thing. Thanks for any help.

 

[James Atexide]

merci

I used Ccur and it worked. Thanks for your help!

What are the data types of these fields? If the are text then you may
have
to do something like Cdbl([Jan Draw]) +Cdbl([Feb Draw])+Cdbl([Mar Draw])
or
what suits you better (Cint, Ccur,..).

This is the formula in my control source
=[Jan Draw]+[Feb Draw]+[Mar Draw]

:

Please show the formula.

:

I am trying to do a sumation field in a report, but instead of
summing the
fields I specify, it is concatenating them. I do use the
formatcurrency
function in some earlier queries on this field, so I am thinking
that is
causing a problem. I even tried summing them in the actual query
and it did
the same thing. Thanks for any help.