Report on Multiple Selections

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have a table with the following fields

strCustomerNam
strCustomerPhoneNumbe
strLineOfBusines
ysnClai
ysnRate
ysnCoverag
ysnServic
ysnServiceAgen
ysnServiceHomeOffic
ysnServiceClaim
ysnBilling
ysnOthe

the fields with prefix ysn are types of customer concern (6 types of Customer concern). If the customer concern are service related, then three yes or no fields ysnServiceAgen
ysnServiceHomeOffic
ysnServiceClaim
are provided for further selection

The reason I treat it as check box is it is likely that a customer concern is both claim related and service related, or both rates related and billing related. In a word, It is a multiple selection problem

But problem happens when I try to report them. I want to know the percentages of the customer concern and draw a chart on the report. Because there is overlapping (ex: a concern is both claim related and service related), I don’t know how to deal with it. I don’t want to list all possible combination of customer concerns. I don’t even know how to run a query that gives me the number of concerns by types of concern. Please help! Thanks
 
Lily

Because of your table design (multiple, repeating fields), you will have to
manually figure out any/all combinations.

Or you could modify your design to have a one-to-many relationship between
Customer and Concern. If you add a new table that holds one row
(CustomerID, ConcernID) for each valid combination, your query & charting
will be much simpler.
 
Back
Top