Generating reports from two or more Access tables

I have just completed my first datebase in Access. Now I need to generate
some reports. The information for these reports are on different tables that
are all linked together by a common field. An example of what I am trying to
do is: off the employee table I need the field EMP_NAME, and off the days
table i need all the fields (DAY_DATE, CODE, HRS, HOLIDAY & NAME_SOC).
NAME_SOC is the linking field between the two tables. I need the report to
show the name, the date, the holiday, # of hrs, and the code for the time
off.

I have access to Crystal Reports and I would like to do my reports in there,
but I run into the same problem there, not being able to access all the data.

Matt

wheelz wrote:

I have just completed my first datebase in Access. Now I need to generate
some reports. The information for these reports are on different tables that
are all linked together by a common field. An example of what I am trying to
do is: off the employee table I need the field EMP_NAME, and off the days
table i need all the fields (DAY_DATE, CODE, HRS, HOLIDAY & NAME_SOC).
NAME_SOC is the linking field between the two tables. I need the report to
show the name, the date, the holiday, # of hrs, and the code for the time
off.

I have access to Crystal Reports and I would like to do my reports in there,
but I run into the same problem there, not being able to access all the data.


As long as you have linking fields in the tables, you can
create a query that Joins to tables. This allows you to use
all the fields from all the tables in your report.

--
Marsh
MVP [MS Access]

wheelz wrote:

I have just completed my first datebase in Access. Now I need to generate
some reports. The information for these reports are on different tables that
are all linked together by a common field. An example of what I am trying to
do is: off the employee table I need the field EMP_NAME, and off the days
table i need all the fields (DAY_DATE, CODE, HRS, HOLIDAY & NAME_SOC).
NAME_SOC is the linking field between the two tables. I need the report to
show the name, the date, the holiday, # of hrs, and the code for the time
off.

I have access to Crystal Reports and I would like to do my reports in there,
but I run into the same problem there, not being able to access all the data.


You can use a query with that as a criteria as the report's
record source.

Alternatively, I usually prefer to use the OpenReport
method's WhereCondition argument to fileter the report
(assuming you use a form button to open the report).

--
Marsh
MVP [MS Access]

wheelz wrote:

I have just completed my first datebase in Access. Now I need to generate
some reports. The information for these reports are on different tables that
are all linked together by a common field. An example of what I am trying to
do is: off the employee table I need the field EMP_NAME, and off the days
table i need all the fields (DAY_DATE, CODE, HRS, HOLIDAY & NAME_SOC).
NAME_SOC is the linking field between the two tables. I need the report to
show the name, the date, the holiday, # of hrs, and the code for the time
off.

I have access to Crystal Reports and I would like to do my reports in there,
but I run into the same problem there, not being able to access all the data.


Marshall Barton wrote:
You can use a query with that as a criteria as the report's
record source.

Alternatively, I usually prefer to use the OpenReport
method's WhereCondition argument to fileter the report
(assuming you use a form button to open the report).


Sorry, this was supposed to posted to a different thread.

--
Marsh
MVP [MS Access]