Mailmerge

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form derived from a table with calculations which has a relationship
with many tables. I wanted to have a query that takes the fields with
calculations and also fields from 2 other tables. I began with the table with
the calc fields but I have just discovered that the table does not include
these calc fields as they change accordingly within the form. How else can I
do this - I need info from the 3 diff tables for a mail merge. Thankyou.
Tracey
 
Hi Tracey

Not quite sure what you are doing as forms generally take info to and from
tables so can't quite see how you have info in the form that is not in the
table unless you are using an unbound control maybe?

Can you do the calculations in the underlying query and then use the query
as the source for your mailmerge?

Sheila
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need creating a query to show the Cost results from the general 1
Mailmerge from Access to Word 16
Conditional Expression 10
Calculated field in a table 6
Remove weekday holiday dates from "between dates" 1
Calculate field with input from different table 5
Launching a Form from Within a Form to Create a New Record 1
Access Form event doesn't work and crashes Access 4

Back
Top