Help with simple Cross Tab query

[moishy101]

Hello all experts,

I'm struggling with a simple cross tab query and would appreciate your help.

I'm trying to create a cross tab query, to list employes and their salaries and bonuses that they got per month.

Here is the table setup:
tblEmployes includes the following fields:
ID
Surname
GivenName
Address
HomePhone
CellPhone
Email

tblSalaries includes the following fields:
ID
SalaryAmount
BonusAmount
Month

The salaries are linked to the employes by the ID field.

[Rabbit]

Put month in the columns, put the employee name in the rows, sum up salary amount and bonus amount.