URGENT PLEASE -- Displaying Query Values on Form

[mvpejp]

I have a simple query that holds the sales outcomes (five possible) for five reps. The rep column is group by, then the sales outcome (group by) then sales outcome (count).

What I have done is enter ten test records all different reps and different outcomes. I want to display on a form that is read only the total sales for rep 1 only by sales outcome category.

So for instance if rep 1 had sold prod1 (once) and prod2 (3 times) my form would have five controls on it. Each control would represent the five products. I would like to display on the form the total 1 for prod1 and 3 for prod2 and '0' for the three other prod.

Unfortunately I can't figure this out and I'm going out of my mind. Any assistance would be truly and greatly appreciated thanks.

MVPEJP

 

[AnnaFoot]

Am I right in assuming you have already created a query that calculates the numbers you want, you just want to be able to display those numbers in a form?

If so you want to use Dlookup as the source for each of the 5 textboxes on the form.

=dlookup("[CountofProd]","NameOfQuery","[prod] = 1")
=dlookup("[countofprod]","NameOfQuery","[prod] = 2")
etc.

Hope that helps,
Anna

 

[Fizzio]

Your question is not quite clear as you seem to be interchanging product with outcome (they may be the same thing but you need to be more explicit about what you are trying to show)
You will no doubt need a form/subform combination to show the rep's details on the main form and their sales Hx on the subform. In order to show all the products / outcomes, the query that supplies the subform should have show all values set to yes and the product / outcome ID as the first field. Does this get you started?

 

[Rich]

I'm sure a crosstab query will give the result you're looking for

 

[mvpejp]

If a crosstab query is the answer then how do I display the results on a form/report?

Advice is good, thank you in advance.

MVPEJP