result of formula shows in access form window but not in table

[Guest]

Fields in Access table view does not display the results of adding two other
fields in form view. All three fields are to be inserted into a form letter.
Also, long date formatting does not merge into letter - it merges with short
date formatting. Long date is displayed in db table and form but not in
letter.

 

[fredg]

Fields in Access table view does not display the results of adding two other
fields in form view. All three fields are to be inserted into a form letter.
Also, long date formatting does not merge into letter - it merges with short
date formatting. Long date is displayed in db table and form but not in
letter.

No need to store the result of a calculation in the table.

Whenever you need the result, recalculate it.
In a query:
TheTotal:[Field1] + [field2]

on a form or report.
=[Field1] + [Field2]

If your form letter is made using MailMerge to Word, use the query to
calculate the result and then use that query field in the mail merge.

If the form letter is done in Access, you can use something like:
= "Please remit the amount of " & Format([Field1] +
[Field2],"Currency") & " by September 1, 2005."

 

[Guest]

fredg-
Thanks! I was about ready to tear out whats left of my hair over this.
Access never was my strong suit and hadn't used it for a while. How soon we
forget.
Thanks again.

Fields in Access table view does not display the results of adding two other
fields in form view. All three fields are to be inserted into a form letter.
Also, long date formatting does not merge into letter - it merges with short
date formatting. Long date is displayed in db table and form but not in
letter.

No need to store the result of a calculation in the table.

Whenever you need the result, recalculate it.
In a query:
TheTotal:[Field1] + [field2]

on a form or report.
=[Field1] + [Field2]

If your form letter is made using MailMerge to Word, use the query to
calculate the result and then use that query field in the mail merge.

If the form letter is done in Access, you can use something like:
= "Please remit the amount of " & Format([Field1] +
[Field2],"Currency") & " by September 1, 2005."