Report Total

[NeonSky via AccessMonster.com]

Hello,

I am having just the strangest occurance in one of my reports. Please see my
sample below which illustrates the issue.

FieldCountry FieldNumber1 FieldNumber2 Total
USA 175,000 200,000
#Num!
CAN 10 25
35

Where "Total" is equal to "=[FieldNumber1] + [FieldNumber2]"

Any ideas on why in one instance I get the proper sum and the other errors
out?

Thank you!

 

[NeonSky via AccessMonster.com]

My totals got dropped to the next line, here is my sample....

FieldCountry FieldNumber1 FieldNumber2 Total
USA 175,000 200,000 #Num!
CAN 10 25
35

Where "Total" is equal to "=[FieldNumber1] + [FieldNumber2]"

 

[Jeff Boyce]

What's the format of the [Total] control?

What happens if you change the formula in [Total] to "=175000 + 200000"
(without the parentheses, of course)?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Stockwell43]

Hi NeonSky,

Just for kicks, have you tried taken out the commas and put the number in as
175000 instead? Also, are the input fields Text or Number and is your Total
field Text or Number. Sometimes you have to play with it but it's funny how
the numbers without the comma totals and the others don't.

Good Luck!

 

[NeonSky via AccessMonster.com]

Thank you Stockwell, though I figured out what the issue was. I was doing a
datatype conversion on my total to CINT which has a max value of around "32,
000", I did a CLNG conversion in my total and that worked. Thank you again
for taking the time to read my post!

Hi NeonSky,

Just for kicks, have you tried taken out the commas and put the number in as
175000 instead? Also, are the input fields Text or Number and is your Total
field Text or Number. Sometimes you have to play with it but it's funny how
the numbers without the comma totals and the others don't.

Good Luck!

My totals got dropped to the next line, here is my sample....

[quoted text clipped - 4 lines]

Where "Total" is equal to "=[FieldNumber1] + [FieldNumber2]"

 

[NeonSky via AccessMonster.com]

Thanks Jeff, I sorted it out!

What's the format of the [Total] control?

What happens if you change the formula in [Total] to "=175000 + 200000"
(without the parentheses, of course)?

Regards

Jeff Boyce
Microsoft Office/Access MVP

My totals got dropped to the next line, here is my sample....

[quoted text clipped - 5 lines]

Where "Total" is equal to "=[FieldNumber1] + [FieldNumber2]"