CCIDBMNG
Registered User.
- Local time
- Today, 02:30
- Joined
- Jan 25, 2002
- Messages
- 154
I'm going to try and explain this the best way I can so please bear with me if it doen't make total sense.
I have two tables
tblSales (is used when am employee makes a sale)
employee
date
tier level
tblTierLevels (shows all the different tier levels and the pay amounts)
tier level
pay amount
I want to create a report which groups by employee and shows every tier level even if they didn't sell any of those tier levels. For example...
Jane Doe Units Pay Total Pay
Tier Level 1: 0 $5.00 $0.00
Tier Level 2: 2 $6.00 $12.00
Tier Level 3: 0 $7.00 $0.00
If I create a query with a join to show all from tblTierLevels and only those from tblSales where tier level = tier level if the employee did not sell any of a certain tier it does not display their name. So I can't group by name and show all tier levels.
If I create a crosstab query this will show all employees as well as all the tiers however this lists the tier levels across (as columns) I want to list the tier levels as rows.
Does anyone know how to do this?
I have two tables
tblSales (is used when am employee makes a sale)
employee
date
tier level
tblTierLevels (shows all the different tier levels and the pay amounts)
tier level
pay amount
I want to create a report which groups by employee and shows every tier level even if they didn't sell any of those tier levels. For example...
Jane Doe Units Pay Total Pay
Tier Level 1: 0 $5.00 $0.00
Tier Level 2: 2 $6.00 $12.00
Tier Level 3: 0 $7.00 $0.00
If I create a query with a join to show all from tblTierLevels and only those from tblSales where tier level = tier level if the employee did not sell any of a certain tier it does not display their name. So I can't group by name and show all tier levels.
If I create a crosstab query this will show all employees as well as all the tiers however this lists the tier levels across (as columns) I want to list the tier levels as rows.
Does anyone know how to do this?
