Database relationships

[Guest]

I need to genetate a report on invoices and applicable tax rate as the
invoices are from different countries.

The details of the invoices are in one table and the country code is in the
same record as the invoice detail, value, etc. within this table.

A second table has the country code and the tax rates for the different
purchases in that country.

I would like to design a report that looks up the tax rate for the invoice
and calculates the amount of tax applicable.

Any assistance greatly appreciated.

Regards

Eddie

 

[Jeff Boyce]

When you need to use data from more than one table in a report, consider
using a query to return the data you need from both tables, joined
appropriately.

Regards

Jeff Boyce
Microsoft Office/Access MVP