By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,294 Members | 2,588 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,294 IT Pros & Developers. It's quick & easy.

Access Reports - Sum total not showing

P: 1
Hi All

Please help, i have a a couple of reports that are playing up on two PC, all other seem to be fine.

The reports are invoices and have three fields at the bottom of the form (Page Footer) each take their data from another three fields which are all sums. These give the Total, VAT and Grand total. When you view the form on the two PC in question, the three fields are blank - however if you click on them the value comes up (printing the form is not an issue as all data come up). However on every other PC the Value is there when you open. Yesterday I made each field Requery on the form "On Load" and all was great on all PC for a few hours (3/4 hrs) now is doing it again. Have tied removing the "On Load" and redoing it and it has not sorted the issue.

Anyone got a clue to why this is happening - The report has been working for 8 months up until this oddity.


Jan 15 '14 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 5K+
P: 5,397

- Have you upgraded the operating system version
- Have you upgraded the office/access install version
- What is the current operating system version
-> is this a client server environment
->-> if this is a client server, then how is the client accessing the application
- What is the current office/access install version
- Have you double checked that the control size is large enough for the displayed data?
Jan 15 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.