If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
field formula
I am creating a form with basic calculations. I encountered no problems until
I tried to set up a subtraction formula with a bookmark that was itself the result of a calculation. Apparently, the bookmarks used in the formula need to have the "number" property, and not "calculation". How can I bypass that? |
#2
|
|||
|
|||
Jessica,
By your use of the terms "number" and "calculation" it sounds like you are using a protected form fields inserted in your table cells. You should not have a problem with using one calculation field result as a variable in a follow on calculation. I inserted 4 fields, double clicked on each and book marked them A B C and D. I set A and B as number fields, C and D as calcultion fields, I checked calculate on exit for all four fields. In C I entered =A-B in D I entered =C-A everything worked fine. Post back with more details if you are still having problems. -- Greg Maxey/Word MVP A Peer in Peer to Peer Support Jessica wrote: I am creating a form with basic calculations. I encountered no problems until I tried to set up a subtraction formula with a bookmark that was itself the result of a calculation. Apparently, the bookmarks used in the formula need to have the "number" property, and not "calculation". How can I bypass that? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Preventing query from converting memo field to text field. | Dennis In Forks | Database Design | 1 | December 22nd, 2004 04:08 AM |
Automated Field | Steve | Running & Setting Up Queries | 8 | December 3rd, 2004 03:12 PM |
ASK Field Behavior | Greg | Mailmerge | 9 | July 2nd, 2004 02:44 PM |
Field list greyed out when trying to add an option group | Tony | Using Forms | 1 | July 1st, 2004 03:40 AM |