Queries

[72185]

I am trying to sum up columns to put the information into a pie chart.
My problem is that I have never used this feature so I am in the dark.


First off my database is a Help Log that records problems that people
within the firm might have. What I am trying to do is show how many
problems each department calls with. So I would like to display on a
pie chart the divisions and how many times they have called.

I keep getting a message with "cannot sometin with a field "*"" but I
have put a value in the field. If anyone has ANY directions at all it
would be greatly appreciated.

-W

 

[Joseph Meehan]

I am trying to sum up columns to put the information into a pie chart.
My problem is that I have never used this feature so I am in the dark.


First off my database is a Help Log that records problems that people
within the firm might have. What I am trying to do is show how many
problems each department calls with. So I would like to display on a
pie chart the divisions and how many times they have called.

I keep getting a message with "cannot sometin with a field "*"" but I
have put a value in the field. If anyone has ANY directions at all it
would be greatly appreciated.

-W

When you say "sum up columns" do you mean you want to sum all the
amounts is one field (column) or you want to sum the amounts in different
fields (columns) in a single record? If the second, your problem is likely
a table design error.



Could you provide a little more information about how your data is
stored.

 

[John Vinson]

I am trying to sum up columns to put the information into a pie chart.
My problem is that I have never used this feature so I am in the dark.


First off my database is a Help Log that records problems that people
within the firm might have. What I am trying to do is show how many
problems each department calls with. So I would like to display on a
pie chart the divisions and how many times they have called.

I keep getting a message with "cannot sometin with a field "*"" but I
have put a value in the field. If anyone has ANY directions at all it
would be greatly appreciated.

-W

Bear in mind that you know the structure of your table and we do
not...

If you're creating a Totals query, you should not select the *
pseudo-field (which actually means to select all the fields in the
table). Try removing it from your query, and then make it a Totals
query (using the Greek Sigma icon) and see if you can sum the
individual fields.

John W. Vinson[MVP]

 

[72185]

When you say "sum up columns" do you mean you want to sum all the
amounts is one field (column) or you want to sum the amounts in different
fields (columns) in a single record? If the second, your problem is likely
a table design error.



Could you provide a little more information about how your data is
stored.

When a person calls in with a problem we solve the problem or take
whatever precautions we need. After we are finished with the problem
we are logging in the information of the problem into the database. I
have many fields, such as, the Division of the company the are calling
from, the Dept they are calling from, the problem/resolution, date
created, the person who took the call and then some other small fields
that I won't be using. Each record is logged in with a number (1, 2,
3, 4.....). What I am trying to do is put some of this information
into a pie chart in excel to present to a manager to show him how many
calls we handle and where they come from. So I am thinking I will need
to use the Dept field and then somehow count how many problems have
came from each Dept. So when I make the pie chart I want to show each
Dept in the ledger and then put the number of calls with each dept. If
you think more should be added I'm open for suggestions. Like I said
earlier I have never really used the Sum part of a query. If you need
more info. please let me know

Thanks for all the help!

-W

 

[Joseph Meehan]

When a person calls in with a problem we solve the problem or take
whatever precautions we need. After we are finished with the problem
we are logging in the information of the problem into the database. I
have many fields, such as, the Division of the company the are calling
from, the Dept they are calling from, the problem/resolution, date
created, the person who took the call and then some other small fields
that I won't be using. Each record is logged in with a number (1, 2,
3, 4.....). What I am trying to do is put some of this information
into a pie chart in excel to present to a manager to show him how many
calls we handle and where they come from. So I am thinking I will
need to use the Dept field and then somehow count how many problems
have came from each Dept. So when I make the pie chart I want to
show each Dept in the ledger and then put the number of calls with
each dept. If you think more should be added I'm open for
suggestions. Like I said earlier I have never really used the Sum
part of a query. If you need more info. please let me know

Thanks for all the help!

-W

Would it look something like this?

ID# Date: Division: Company: Department: CallTaker:
1 1/1/06 Transport ACME Trucks Frank
2 1/1/06 Training ACME Library Peggy

 

[72185]

Would it look something like this?

ID# Date: Division: Company: Department: CallTaker:
1 1/1/06 Transport ACME Trucks Frank
2 1/1/06 Training ACME Library Peggy

Pretty much just without the Date and Division. Would you have any
idea on how to set that up?

Thanks!

-W

 

[Joseph Meehan]

Pretty much just without the Date and Division. Would you have any
idea on how to set that up?

Thanks!

-W

OK make a query based on the table with the information. Put the
Department filed in there and then use that or another field with data in
every record you want to count and make that field a "Count" field. Change
it using the drop down selection offered when you click on the "Sum."

Does that help?

 

[72185]

OK make a query based on the table with the information. Put the
Department filed in there and then use that or another field with data in
every record you want to count and make that field a "Count" field. Change
it using the drop down selection offered when you click on the "Sum."

Does that help?

Well I'm still not sure on how to set it up. That did make sense but I
do not know how to incorporate it with what I want to do. I think I'm
thinking about it to hard. I want to count how many problems each
department had. Not the specific problem the how many times they have
called. Right now I have just two fields in the query. It is set up
like:

Department Problem
Count
Group by: Group by:

"Accounting"

And it is giving me a message that says "Cannot read a field with "*"
but there aren't any fields grouped by "*". Any ideas? Thanks for
all your help!

-W

 

[72185]

Well I'm still not sure on how to set it up. That did make sense but I
do not know how to incorporate it with what I want to do. I think I'm
thinking about it to hard. I want to count how many problems each
department had. Not the specific problem the how many times they have
called. Right now I have just two fields in the query. It is set up
like:

Department Problem
Count
Group by: Group by:

"Accounting"

And it is giving me a message that says "Cannot read a field with "*"
but there aren't any fields grouped by "*". Any ideas? Thanks for
all your help!

-W

Ok well I got the query working close enough to the information I need.
Is there anyways to use parameters to ask them the dates they need. I
have it set up like above, except I added the "Date Created" field and
used grouped by "avg" and am using a Between And Criteria to put the
dates in. Is there anyway I can use parameters to ask the dates?

Thanks
-W