summary field not displaying

[DKP]

I have a form w/ a query as a record source. The detail section displays multiple records and in the footer I have a text boxes w/ the control source set to something like the following to displays totals for the various columns.



=Sum([amount])

Recently, these total fields have stopped displaying. I thought it may have been some other seemingly unrelated changes I was making, but I reverted them and the problem still persists. I copied the same database to another machine it works fine.

Has anyone seen anything like this before? Any idea how to resolve this?

[Dal Jeanis]

Okay, so the symptom is that the database works right on one machine and wrong on the other.

So, the first thing to investigate is the differences between the machines.

Even before that, I would do a hard reboot of the machine that has the error, leave it powered all the way down for at least 30 seconds, then restart it. Do this twice, to clear out any software updates or gremlins in residence. Then test your issue.

After that, determine what version of all relevant software is on each machine, and what is their connection/relationship to the database (assuming it's on a LAN or split frontend/backend). Figure out what add-ins are installed in Access on each machine. If there are any differences, then do a gut-check to see if they might be relevant.

After that, post what you found and we'll kibbitz some more.

[Missinglinq]

When apps run fine on one machine and not on another, or run fine in one version and not when run under a newer version, one of the first things you have to think about are missing references. The fact that Access is balking on syntax that involves a Function (Sum()) makes this seem even more likely than usual.

If you haven't checked for this kind of thing before, here are Doug Steele's detailed instructions on how to troubleshoot the problem:

Access Reference Problems

Linq ;0)>