MS Access: Custom reports generation

0
votes

I have two tables in an MS Access database as shown below.

Employee table:

enter image description here

Salary table:

enter image description here

I have created a query for the summary of salaries for each employee, to be shown as Year based.

Query:

SELECT Employee.EmployeeID, Employee.Name, Salary.AnnualYear, 
Salary.MinSalary, Salary.Salary, Salary.MaxSalary
FROM Employee INNER JOIN Salary ON Employee.EmployeeID=Salary.EmployeeID;

Query result:

enter image description here

What I want to achieve is,

To create a Report to show the details as Year based.

Report achieved so-far:

enter image description here

expected report:

enter image description here

Will Report wizard be able to help me to achieve the expected report?

Or Do I have to do any VBA programming?

MS Access file

2
ms-accessreportms-access-2007reporting

2 Answers

1
votes

What you are looking for is a Pivot table. You can take your existing query and switch to PivotTable View (open the query, right click on the tab and select PivotTable View). This results in something that looks like: Graphic of Pivot Table

As requested. I have saved that in your file. Find it here.

0
votes

Report wizard should be able to achieve that report.