Re: highest percenatage

Build One query with customer ID, brand, and Count(*), in another
query, reference query 1 and pull the max brand for each customer, call
this query 2. This should list the top brand for each customer. Link
this query in your original by customer ID, pull down the brand field.
Hope this helps, otherwise, give me specific names of the fields with a
smaple record or two



tess@xxxxxxxxxxxxxx wrote:
I'm not following you.

If i query customer id and max brand, i'd get the max brand of all
customers.. I need to get it for each customer.
AP wrote:
A quick and dirty way may be to create a new query with just the
customer id and max brand, then link that query into the existing
query, the max brand will then repeat for every customer record.

tess@xxxxxxxxxxxxxx wrote:
What I need is to find out brand preference per customer. I have
records showing how many of each brand they have purchased in the last
5 years. I can easily create a crosstab query that will calculate
totals per brand per customer. But, what I need is to determine brand
preference, by comparing the number of each brand to the total
purchased to get a percentage. Easy enough... but I need do have a
field that will find the highest percentage per customer, and populate
with that brand name so I can have a 'brand preference' field.

Can someone point me in the right direction?

.

Relevant Pages

  • RE: Form/Subform combo box dependent combo box
    ... I have the combos for customer and brand working great now on the main form. ... Now I'm running into getting the Project subform to stay referential to the ... Use the main form to display the customer and brand information. ...
    (microsoft.public.access.forms)
  • RE: Form/Subform combo box dependent combo box
    ... I'm not sure how to set up the subform ... I have the combos for customer and brand working great now on the main form. ... Use the main form to display the customer and brand information. ...
    (microsoft.public.access.forms)
  • RE: Form/Subform combo box dependent combo box
    ... the subform control on the main form. ... I have the combos for customer and brand working great now on the main form. ... Now I'm running into getting the Project subform to stay referential to the ...
    (microsoft.public.access.forms)
  • Re: "We kept Wal-Mart out of our town!"
    ... lighter weight version of "personal size" frozen pizzas of a specific ... brand. ...  All merchandise is presented in its original packaging, ... customer concerns. ...
    (alt.home.repair)
  • RE: Form/Subform combo box dependent combo box
    ... Use the main form to display the customer and brand information. ... Use a subform for the project info. ...
    (microsoft.public.access.forms)