I need to calculate 20% of column X, then add X to Y, then connect table to a mail merge document

[Silkyilky]

I have a database containing names, addresses and cash amounts.



I need to connect this to a mail merge document to produce invoices with an invoice number, names, addresses, cash amounts, VAT and a grand total.

Can anyone help please?

[writeprivate]

This seems relatively simple. But you need to provide more information in order for anyone to give you the solution. Are you using a query? You could create an expression to do the calc. Or is this within a form, you could use VBA. Also is X the new total or the 20%

[June7]

Have you tried anything yet? Exactly what issue have you encountered?

Why use Mail Merge and not Access report?

[Welshgasman]

Create a query with the data you need plus any calculations.
Then use that as your source for the mailmerge.

Alternatively just create a report with same data, or carry out calculations in report.

[Silkyilky]

Thanks Welshgasman, I will provide more information asap