adding a record

T

tmoore

is there a way to have access do a calculation to a single record ?

basically field + field + field = have the results post in a field? or page
or email?. ive looked high and low and suspect that im just not finding the
source.
 
R

Rick B

Sure. On you form or report, place an unbound textbox and put the following
in it....

= [SomeField] + [SomeField] + [SomeField]


In a query, you would place the following in a blank column...

NewCalculatedName: [SomeField] + [SomeField] + [SomeField]



Hope that helps,

Rick B
 
T

tmoore

when i try to create a report/form or query i get a error saying to may
fields. i am trying to add/cal approx 100 fields in a single record in the
table mode. basically
field1 + field2+3+4+5+6 100 times = a total
 
L

Larry Daugherty

Your data design is flawed as far as Access is concerned. On the other
hand, it would work just fine in Excel just as you've described it.

Each of those fields you're trying to add together should really be
rows/records in a table. The parent table should be about the entity in
your row header to the left That table would have a primary key and a few
fields regarding the entity.. The child table would have its own primary
and would have a Long Integer, Foreign Key entry which is the primary key of
the parent table.

With your new data you can now create Totals queries that will do exactly
what you want. You might lurk microsoft.public.access.gettingstarted and
microsoft.public.access.tablesdesign to get some ideas about proper table
design.

HTH
 
Top