Generating reports from two or more Access tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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.
Click to expand...


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.
 
wheelz said:
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.
Click to expand...


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).
 
Marshall said:
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).
Click to expand...


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