G
Guest
I have a query that is pulling records based on sales rep and date. The
total number of records determines a commission tier. I have the both tables
in my query (sales info and commission tiers). I would like to only show the
commission tier that is applicable based on the total number of sales. I
need to somehow total the number of records and display it in a column. Is
this possible?
total number of records determines a commission tier. I have the both tables
in my query (sales info and commission tiers). I would like to only show the
commission tier that is applicable based on the total number of sales. I
need to somehow total the number of records and display it in a column. Is
this possible?