Mailmerge

S

SCP

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
 
S

Sheila D

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
 
Top