Adding two subreports together

[David Tunstall]

Thanks Alp, but that still doesn't do it!

Please help,

I have tried every expression I know to add together two
subreports on a report and the closest I can get is where
it puts the two values together and doesn't actually add
them:

A1.Count = 2
A2.Count = 8

The following expression gives me 28 instead of 10

=[A1].[Report]![Count]+[A2].[Report]![Count]

Please help
Thanks
David

 

[Glenn]

Try:

=cLng([A1].[Report]![Count]) + cLng([A2].[Report]![Count])

Rgds,
Glenn.

 

[Alp Bekisoglu]

Sorry that it did not help you out David. It looks like it is treating your
sources as text and then combines them together. Have you tried formatting
your source "count" textboxes? to , say, "Standard"...

My totals in the sub-reports are formatted as such as well as the sum on the
main report.

Anyway, good luck.

Alp