Software

Ask something
Discussion Locked

Access Report Data from Two Tables

0 helpful
7 replies

by js6

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

7 replies

by richtee

The following are a couple of ways that may help you accomplish what you want to do.

First method: Create a query based on the two tables. Create a report based on the query.

Second method: Create a report based on each table. Insert one report as a sub report to the other.

by donq

Create a query based on the two tables. Create a report based on the query with the following entry in a Report Header Text Field.

="Business Date " & [DateFieldName]

substitute the Field Name "DateFieldName" from above to whatever you namedthe field containing the date value you want displayed.

This discussion is closed to new replies.