If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
totals not visible from 2k to 2k3
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? -- terri |
#2
|
|||
|
|||
totals not visible from 2k to 2k3
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 Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "terri" wrote in message ... 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? |
#3
|
|||
|
|||
totals not visible from 2k to 2k3
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" wrote: 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 Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "terri" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|