totals not visible from 2k to 2k3

  • Thread starter Thread starter terri
  • Start date Start date
T

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? :(
 
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
 
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


Allen Browne said:
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.

terri said:
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? :(
Click to expand...
Click to expand...
 
Back
Top