Sums in a table?? help!!

E

emmy128

How do i get the last column of the row in a table to calculate the sum of
the numeric fields of that row??? (please be very specific!)

also, how do i get the current date and time to show up in a text box in a
form??

pleease help!!

thanks a million!

Cheers
 
T

tina

you don't - in a table. if you want to sum certain fields in a record, do it
with a calculated field in a query, as

FieldsTotal: Field1 + Field2 + Field3 (etc, etc, etc)

to show current date/time in a form, add an unbound textbox in design view,
and set the control's ControlSource property to

=Now()

hth
 
M

Mike Painter

emmy128 said:
How do i get the last column of the row in a table to calculate the
sum of the numeric fields of that row??? (please be very specific!)
Click to expand...
You would have to write an update query that places those values in the last
field.

There is about a 99.5% certainty that what you are trying to do is wrong.
I'm being generous with the last .5%
If you have a valid reason for wanting the sum of the fields a query is a
better way to do it, using a calculated field.
Chances are that those fields should be in another table.
also, how do i get the current date and time to show up in a text box
in a form??
Click to expand...
By setting the default value to Now() and formatting the text box.
 
Top