How to create plenty of columns in a report

[petrak]

Hi everybody, I'm new in this forum. I need some help. I'm creating a program for my job and I must create a report that shows a row with each employee name and some columns that show the months of the year. In the columns, employees' salaries should be recorded. I need something like the attachment below:


(ps may be i will need to create some union queries)
Thanks in advance...

[goodguy]

Do you have a table structure defined? You need the following tables:
tblEmployees - Primary key: "EmployeeID", Currency field "Salary"
tblSalaries - PrimaryKey: EmployeeID + DatePaid

You can then create a query to return Employee Name and Salary Amount from tblEmployees and Date Paid from tblSalaries and define your report based on that.