Data from 2 Tables

[jekart]

Hi All, hoping you can help solve a problem I am stuck. I am not that experienced in this realm so please bare with me.

I created a database to record payment information my company receives for permits. It is stored in the ledger_tbl.
I have another table that contains the name, mailing address etc of all of the municipalities we work for - customers_tbl.



I am working on a report to create an invoice for the amount of permit fees we receive during a given time period. The report is retrieving all the payment specific information from the query ledger_qry. Everything is working beautifully except for 1 part, which is I want the invoice report to retrieve the customers name and mailing address from the customers_tbl based off a criteria I set in ledger_qry which is done as [enter jurisdiction].

Hopefully this makes sense, if you need any additional info let me know.
Thank you for your assistance.

Jekart

[JoeM]

Join your two tables together in your query (there should be a common customer id field in both table to join on).

[jekart]

That worked!!! Thank you JoeM!

[JoeM]

You are welcome.