Access Reports - Sum total not showing

[Wayne Hemmings]

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.

Yours

Wayne

[zmbd]

BE VERY SPECFIC:

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