totals not visible from 2k to 2k3

[terri]

i have a database in 2k and when someone with 2k3 runs a report, the totals
don't show.
it's a productivity report so it reports by each person.
each person has a header/footer....the totals are in the footer.
the totals in the footer read the running sum in the detail section.
she is not blocking unsafe stuff when she opens the database.
what could it be?

 

[Allen Browne]

Suggestions:

1. Instead of using a Running Sum text box in the Detail section, would it
be possible to set the Control Source of the text box in your Person Group
Footer to an expression such as:
=Sum([SomeField])

2. If that's not possible, perhaps Access is not understanding the data type
of the field correctly. Tell us about the field/expression you are trying to
sum.

3. Make sure you have at least Service Pack 8 for JET 4 on the A2003
machine. Source:
http://support.microsoft.com/kb/239114

 

[terri]

the first one worked beautifully !! thank you so much !
i can't believe i actually got Allen Browne to answer one of my questions!!
i'm so happy!!

--
terri

Suggestions:

1. Instead of using a Running Sum text box in the Detail section, would it
be possible to set the Control Source of the text box in your Person Group
Footer to an expression such as:
=Sum([SomeField])

2. If that's not possible, perhaps Access is not understanding the data type
of the field correctly. Tell us about the field/expression you are trying to
sum.

3. Make sure you have at least Service Pack 8 for JET 4 on the A2003
machine. Source:
http://support.microsoft.com/kb/239114

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

i have a database in 2k and when someone with 2k3 runs a report, the totals
don't show.
it's a productivity report so it reports by each person.
each person has a header/footer....the totals are in the footer.
the totals in the footer read the running sum in the detail section.
she is not blocking unsafe stuff when she opens the database.
what could it be?