cut and paste into table issue

[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

 

[Guest]

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.

 

[Guest]

LOL, that should say:

You shouldn't cut/paste directly into a table

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.

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

 

[Guest]

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.