On 27 Sep 2004 14:30:10 -0700, JFTE wrote:
I have managed a table which consists of four fields, [Name], [Test1],
[Test2] and [Total]. Using a form I can add up the [Test1] and
[Test2] fields, but i would like to store that result in the [Total]
field.
Is this possible, and how do I manage it?
Thanks.
1) If you really do have a field named "Name" I would strongly suggest
you change it. Name, as well as many other words is a Access/VBA
reserved word and should not be used as a field name.
See Microsoft KnowledgBase articles:
321266 "ACC2002: Microsoft Jet 4.0 Reserved Words"
209187 "ACC2000: Reserved Words in Microsoft Access"
286335 "ACC2002: Reserved Words in Microsoft Access"
2) If you store the data in [Test1] and [Test2] in a table, there is
no need to store the calculated total.
Whenever you need that total (on a form, in a query, or in a report),
recalculate, using the same expression you are now using.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.