Individual as well as overall averages problem

[ptaylor-west]

I have created 2 queries from the same table.

The first allows me to run information by entering a Company Name "Like[Enter Company Name]" The results displays all the information for that particular Company Name and all the Salesmen in that company.... fine so far.

The second is simply the same information grouped by average of the same information as used in the first query but without Company Name or Salesmen or Salesman fields, so it gives me just one line of the overall averages... still fine.

I am then attempting to produce a report from the two queries, so that I have information by a selected Company Name and their Salesmen, which I also want to summarise for the average of the Salesmen overall... this is no problem on its own, however before I even get that far if I try to add the second query I get an error message sayinh that I am trying to access information from the same table/query and will not run.

My objective for the second query is so that it gives a constant average for all Company Names so that the selected Company Name can be compared to others.

At that point HELP!

 

[ptaylor-west]

Does anyone have any ideas? I'm really stuck with this

 

[mresann]

Can you post the query statements in particular?

 

[ptaylor-west]

I have attached screen shots of the queries, as you can see they both use the "Summary" table as the source of info. The first allows you to select output by "Dealer" and the second is to give an average for all "Dealers".

Is this helpfull?

 

[GabrielR]

maybe the answer on your other post can help you.

 

[ptaylor-west]

Thank you it did, for other viewers this same thread was posted on the query section.