General discussion
August 10, 2001 at 04:22 PM
js6

Access Report Data from Two Tables

by js6 . Updated 24 years, 9 months ago

I import data from another system. One of the tables has all of the account data (acct no, plan, type, balance, available credit, etc.) and the second table has the business date (one field with one record 08/10/01). I would like to have the business date in the report header of reports. I tried the current date but the business date is what is needed. I think I need to pull data from the Account table and the Date table. How do I do this?

This discussion is locked

All Comments