cut and paste into table issue

Z

Z

I have a formula =SUM([RECEIVED]-[ISSUED]) when i input into the form
the numbers will update and will work, however, when i try to copy and
paste records into the table and i open the form back up the forumla
only works for the items that i typed in manually and not the ones that
i cut/pasted into the table -- any ideas why or how i can get around
this?

Z
 
X

xRoachx

Z, as a general rule, you shouldn't stored calculated values and you should
cut/paste directly into a table. Caculated fields don't need to be stored
b/c they can always be calculated at any time. If you need to add records to
a table, use a form.
 
K

KARL DEWEY

If your fields are text fields used in the math the problem could be you have
a leading space or some other character when you copied/pasted.
 
Top