Exporting a Summary Report from Access to Excel

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

Guest

I have a very large database (17,059 rows of data) for approximately 500
employees. It is a list of all checks issued and the type of income earned.
I am trying to export this data in a summary form, which I have created on a
report, but am running into some difficulty.

The report exports the summary infomation, but is not including the
employee's name or id number, only the "summed data". Any suggestion? I
need only the summary data for an analysis that is due next week. Any
assistance would be appreciated.
 
Hi Tammi,

Start by creating a totals query that summarises the data, grouping by
employee ID. Then create a second query that joins the first one to the
employees table on employee id and gets the name or any other employee
data you need.
 
John,

I have the summary totals query already created and group, but how do I join
a second query? I am sorry, but I am new to Access so perhaps this is a
simple question.
 
Tammi,

1) Make sure your existing totals query includes the employee id field
(which should be the primary key of the table with the employee data).

2) Create a new query in the usual way, an ordinary Select query. For
its data sources, pick (a) your existing totals query and (b) the table
with the employee data.

3) If necessary, drag the employee id field from the field list for the
totals query onto the employee id field in the employee table, creating
a join shown by a line.

4) Drag the fields you need from the two field lists into the grid.

5) Save and test the query, then use it as the data source for your
report.
 
Back
Top