Creating a Group By query from more than one table

[Guest]

Is it possible when creating a report that includes the results of this
query, to also create a pie chart or bar graph using the query information?

And is it possible to tally results from more than one table list on the
same Group By query?

 

[John W. Vinson]

Is it possible when creating a report that includes the results of this
query, to also create a pie chart or bar graph using the query information?

Sure. They'd be independent objects though.

And is it possible to tally results from more than one table list on the
same Group By query?

YOu'll have to explain what you mean. A Group By query can certainly be based
on two or more tables, but you have posted nothing which would allow us to
suggest how. What are these tables, and how are they related? Or are they
multiple tables with basically the same structure which you want to string
together into one recordset?

John W. Vinson [MVP]

 

[Arvin Meyer [MVP]]

Is it possible when creating a report that includes the results of this
query, to also create a pie chart or bar graph using the query
information?

Yes, although I'd send the data from the query to Excel (before 2007
version) and run the graph there. If you are using Access 2007, you will
probably do better sticking to its graphing engine.

And is it possible to tally results from more than one table list on the
same Group By query?

If the tables can be joined on a key, you can do a Totals query.

 

[Guest]

I apologize here is a sample of the original table

For Example:

Name ID Phone Call Outcome
Jane Doe ****** (999) 555-1234 No Answer
John Doe ****** (999) 555-2345 Left Voicemail
Jana Doe ****** (999) 555-3456 Wrong Number
Josh Deo ****** (999) 555-5467 Disconnected

the Call Outcome column is selections from a drop down box. the Group By
query totaled for me how many of each outcome was selected throughout the
list. The results of the query were then displayed something like this:

No Answer 5
Wrong Number 2
Disconnected 8
Left Voicemail 4
Spoke to Student 25

Now my employees are all calling from different list in the database but i
need to combine the results of each list in one query if possible.
I also need to then have a pie chart to display in percentage form the
results of the Group By query.

Is this doable?

 

[John W. Vinson]

I apologize here is a sample of the original table

For Example:

Name ID Phone Call Outcome
Jane Doe ****** (999) 555-1234 No Answer
John Doe ****** (999) 555-2345 Left Voicemail
Jana Doe ****** (999) 555-3456 Wrong Number
Josh Deo ****** (999) 555-5467 Disconnected

the Call Outcome column is selections from a drop down box. the Group By
query totaled for me how many of each outcome was selected throughout the
list. The results of the query were then displayed something like this:

No Answer 5
Wrong Number 2
Disconnected 8
Left Voicemail 4
Spoke to Student 25

Now my employees are all calling from different list in the database but i
need to combine the results of each list in one query if possible.
I also need to then have a pie chart to display in percentage form the
results of the Group By query.

Is this doable?

Again... I don't understand. It sounds like you're using different
terminology. Does each employee use A DIFFERENT ACCESS TABLE (is that what you
mean by "list")? If so, that's really not good design! You can use a UNION
query (see the Help file for UNION, it's pretty good) to combine data from
multiple tables "end to end" - but union queries can be slow and it's
certainly not something I'd want to rely on.

John W. Vinson [MVP]

 

[Guest]

Yes each employee is using a different table because the tables contain
different sections of the data list. One list contains A-E, the 2nd list
contains F-I, etc. and there is a reason for that, but my main concern was
for the chart.
how do i get the chart to display the reults of the query in percentage form
as opposed to what its doing now. curerntly its displaying 1 color and 100%
in the report view but in the Design View the Chart is displayed correctly. i
am thouroughly confused on this. can u help?

 

[John W. Vinson]

Yes each employee is using a different table because the tables contain
different sections of the data list. One list contains A-E, the 2nd list
contains F-I, etc. and there is a reason for that, but my main concern was
for the chart.

Still: THIS DESIGN IS WRONG.

If you want one user to see records from A to E, and another user to see
records for F through I, you should have *one* table; each user would be using
a Form bound to a Query selecting a subset of the records. The query will be
updateable; the users will be viewing different sets of data so there will be
no conflicts; the queries will still be updateable.

how do i get the chart to display the reults of the query in percentage form
as opposed to what its doing now. curerntly its displaying 1 color and 100%
in the report view but in the Design View the Chart is displayed correctly. i
am thouroughly confused on this. can u help?

Since you don't say what you're doing now, that is a mite difficult to answer!
You may need to calculate the percentage in a calculated field by dividing the
sub-counts by the grand total count. If you could post the SQL view of the
query for which you posted the results, it should be possible to modify it to
give you the percentage you want.

John W. Vinson [MVP]