I want to use a calculated field in a word mail merge, but all the other information is from the table, how can I split it?
Posted on 2005-04-26
I want to use a calculated field in an access form in a mail merge. But, when it merges, it's blank. This is as I am getting the information from the table, not the similarly named calculation field. I need to link the calculated field to input information in the table to merge it to a word doc. Here's the scenario, we are a law firm. We have an access data base to calculate a "demand amount," lets say, $500.00. The statute this case falls under allows for TRIPLE damages. So, in an input form, our data entry people type...$500.00 for the [Demand amount]. This control is bound to the table, so the table field says, "$500.00." I also have a calculated FORM field called, [triple damages amount] which control states =[demand amount]*3. I want this field to place the calculated information into the TABLE for [triple damages], BUT I DO NOT KNOW HOW TO PROGRAM.
The purpose of this field is to create automated lawsuits as these are small nuisance suits under $5,000.00. We have hundreds of them, so the complaints (lawsuits) need to be automated. I created a mail merge for the complaint (which works fantastic, except for calculated fields, all these are blank)...but one of the fields must be the [triple damages amount] in the complaint. A mail merge only works off one table so I can't use multiple forms or queries. How can I get a calculated field to update a table when both controls are named identically.
I basically need to state:
When I input $500 in the form field [form!damages], multiply it by 3 ([form!damages]*3), and place the answer on this form field (form!triple damages)(=[form!damages]*3) but also, load this answer into a table field called triple damages ([table!triple damages]; how do I do this part, where is it entered, and what is the specific command?); once the table is updated, I can use my existing mail merge (which is 37 pages long with multiple fields (about 200 fields throughout the merge and input form, I'd prefer not to rewrite the merges if possible). Please help you guys/gals...and by the way, thank you all in advance for your assistance.