Problem with combining same field query!!!!!

#1 (**permalink**) 28-Jul-2006, 08:25 AM

I am creating a database for my job that deals with getting information about
workload in different areas. What I want to do is bar chart the information
in way that would compare each area but what I need to do first is create a
query that has each area listed so I can chart each individual field. The
comparison all comes from one field (Design Hours) which is located in my
table and I need to come up with a new query that will divide the Design Hour
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11929-problem-with-combining-same-field-query.html
field into three different areas. So to sum up what I want, basically I want
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11929
to filter out the Design Hours field from the table and then in the query
have Area1 field and the design hours for that area, Area2 field and the
design hours for that area, and Area3 field and the design hours for that
area. I am an intern and I am extremely new to access, this is my first
database so can anyone help me please!!!!

#2 (**permalink**) 28-Jul-2006, 08:25 AM

Hello "Kwgame".

"Kwgame" wrote:
> I am creating a database for my job that deals with getting information
> about workload in different areas. What I want to do is bar chart the
> information in way that would compare each area but what I need to
> do first is create a query that has each area listed so I can chart each
> individual field. The comparison all comes from one field (Design Hours)
> which is located in my table and I need to come up with a new query
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11929
> that will divide the Design Hour field into three different areas. So to
> sum up what I want, basically I want to filter out the Design Hours
> field from the table and then in the query have Area1 field and the
> design hours for that area, Area2 field and the design hours for that
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11929
> area, and Area3 field and the design hours for that area. I am an
> intern and I am extremely new to access, this is my first database
> so can anyone help me please!!!!

How is the table designed? Does it contain an area field?

--
Regards,
Wolfgang

#3 (**permalink**) 28-Jul-2006, 08:25 AM

Hey "Kais"

"Wolfgang Kais" wrote:

> Hello "Kwgame".
>
> "Kwgame" wrote:
> > I am creating a database for my job that deals with getting information
> > about workload in different areas. What I want to do is bar chart the
> > information in way that would compare each area but what I need to
> > do first is create a query that has each area listed so I can chart each
> > individual field. The comparison all comes from one field (Design Hours)
> > which is located in my table and I need to come up with a new query
> > that will divide the Design Hour field into three different areas. So to
> > sum up what I want, basically I want to filter out the Design Hours
> > field from the table and then in the query have Area1 field and the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11929
> > design hours for that area, Area2 field and the design hours for that
> > area, and Area3 field and the design hours for that area. I am an
> > intern and I am extremely new to access, this is my first database
> > so can anyone help me please!!!!
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11929
>
> How is the table designed? Does it contain an area field?
>
> --
> Regards,
> Wolfgang
>
>
>

#4 (**permalink**) 28-Jul-2006, 08:25 AM

Hello "Kwgame".

"Kwgame" wrote:
>>> I am creating a database for my job that deals with getting information
>>> about workload in different areas. What I want to do is bar chart the
>>> information in way that would compare each area but what I need to
>>> do first is create a query that has each area listed so I can chart each
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11929
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11929
>>> individual field. The comparison all comes from one field (Design Hours)
>>> which is located in my table and I need to come up with a new query
>>> that will divide the Design Hour field into three different areas. So to
>>> sum up what I want, basically I want to filter out the Design Hours
>>> field from the table and then in the query have Area1 field and the
>>> design hours for that area, Area2 field and the design hours for that
>>> area, and Area3 field and the design hours for that area. I am an
>>> intern and I am extremely new to access, this is my first database
>>> so can anyone help me please!!!!

>> How is the table designed? Does it contain an area field?

> Hey "Kais"

This is too little information to answer your question ;-)

--
Regards,
Wolfgang

#5 (**permalink**) 28-Jul-2006, 08:25 AM

Thanks for your response Karl. I implemented the SQL but I keep getting
that I have to enter the parameters. I changed Cutomer to my table name.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11929
What I want my new query to look like is I want field 1 to be sorted with the
names that are in charge of that area ("name", "name2") and then in the
second field in that query I want have all the Design Hours associated with
those names. I don't even need to sum them up cause that automatically
happens in the chart which is where I want to take the information from the
query. The two fields I am trying to take from my table are User Contact
("name") and Design Hours. Can you please tell me what I need to do?

"KARL DEWEY" wrote:

> Substitute your table name for Customer.
>
> SELECT Customer.Area, Sum(Customer.Design_Hours) AS SumOfDesign_Hours
> FROM Customer
> GROUP BY Customer.Area;
>
>
> "Kwgame" wrote:
>
> > I am creating a database for my job that deals with getting information about
> > workload in different areas. What I want to do is bar chart the information
> > in way that would compare each area but what I need to do first is create a
> > query that has each area listed so I can chart each individual field. The
> > comparison all comes from one field (Design Hours) which is located in my
> > table and I need to come up with a new query that will divide the Design Hour
> > field into three different areas. So to sum up what I want, basically I want
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11929
> > to filter out the Design Hours field from the table and then in the query
> > have Area1 field and the design hours for that area, Area2 field and the
> > design hours for that area, and Area3 field and the design hours for that
> > area. I am an intern and I am extremely new to access, this is my first
> > database so can anyone help me please!!!!

#6 (**permalink**) 28-Jul-2006, 08:25 AM

Here is a little more help with showing you what I want.
from table:
UserContact DesignHours
Name1 34
Name1 56
Name2 55
Name3 23
Name2 65

new query:
DesignHoursName1 DesignHoursName2 DesignHoursName3
34 55 23
56 65 22
66 36 44
45 25 27

I want each field to be sorted by the name associated with those Design
Hours. So basically I want each field to be based on two field from the
table and then output to the new query.

"KARL DEWEY" wrote:

> Substitute your table name for Customer.
>
> SELECT Customer.Area, Sum(Customer.Design_Hours) AS SumOfDesign_Hours
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11929
> FROM Customer
> GROUP BY Customer.Area;
>
>
> "Kwgame" wrote:
>
> > I am creating a database for my job that deals with getting information about
> > workload in different areas. What I want to do is bar chart the information
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11929
> > in way that would compare each area but what I need to do first is create a
> > query that has each area listed so I can chart each individual field. The
> > comparison all comes from one field (Design Hours) which is located in my
> > table and I need to come up with a new query that will divide the Design Hour
> > field into three different areas. So to sum up what I want, basically I want
> > to filter out the Design Hours field from the table and then in the query
> > have Area1 field and the design hours for that area, Area2 field and the
> > design hours for that area, and Area3 field and the design hours for that
> > area. I am an intern and I am extremely new to access, this is my first
> > database so can anyone help me please!!!!

#7 (**permalink**) 28-Jul-2006, 08:25 AM

This will give you one row in the results.
TRANSFORM Sum(Kwgame.DesignHours) AS SumOfDesignHours
SELECT Kwgame.x
FROM Kwgame
GROUP BY Kwgame.x
PIVOT Kwgame.UserContact;

Your results example shows four rows. What would make the output contain
four rows?

It would be a whole lot easier and less time consumming if you posted your
table structure and a sample of data like Wolfgang suggested.

"Kwgame" wrote:

> Here is a little more help with showing you what I want.
> from table:
> UserContact DesignHours
> Name1 34
> Name1 56
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11929
> Name2 55
> Name3 23
> Name2 65
>
> new query:
> DesignHoursName1 DesignHoursName2 DesignHoursName3
> 34 55 23
> 56 65 22
> 66 36 44
> 45 25 27
>
> I want each field to be sorted by the name associated with those Design
> Hours. So basically I want each field to be based on two field from the
> table and then output to the new query.
>
> "KARL DEWEY" wrote:
>
> > Substitute your table name for Customer.
> >
> > SELECT Customer.Area, Sum(Customer.Design_Hours) AS SumOfDesign_Hours
> > FROM Customer
> > GROUP BY Customer.Area;
> >
> >
> > "Kwgame" wrote:
> >
> > > I am creating a database for my job that deals with getting information about
> > > workload in different areas. What I want to do is bar chart the information
> > > in way that would compare each area but what I need to do first is create a
> > > query that has each area listed so I can chart each individual field. The
> > > comparison all comes from one field (Design Hours) which is located in my
> > > table and I need to come up with a new query that will divide the Design Hour
> > > field into three different areas. So to sum up what I want, basically I want
> > > to filter out the Design Hours field from the table and then in the query
> > > have Area1 field and the design hours for that area, Area2 field and the
> > > design hours for that area, and Area3 field and the design hours for that
> > > area. I am an intern and I am extremely new to access, this is my first
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11929
> > > database so can anyone help me please!!!!

#8 (**permalink**) 28-Jul-2006, 08:25 AM

What I really want to do is compare the hours for 4 different groups in a
chart format and to do this I have to make a query with the 4 different group
hours since I cannot take the DesignHour coloumn from four different query or
I get a message
that says I can't take fields from a table and a query based on a table.
Access really sucks when it comes to graphing!!

"KARL DEWEY" wrote:

> This will give you one row in the results.
> TRANSFORM Sum(Kwgame.DesignHours) AS SumOfDesignHours
> SELECT Kwgame.x
> FROM Kwgame
> GROUP BY Kwgame.x
> PIVOT Kwgame.UserContact;
>
> Your results example shows four rows. What would make the output contain
> four rows?
>
> It would be a whole lot easier and less time consumming if you posted your
> table structure and a sample of data like Wolfgang suggested.
>
> "Kwgame" wrote:
>
> > Here is a little more help with showing you what I want.
> > from table:
> > UserContact DesignHours
> > Name1 34
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11929
> > Name1 56
> > Name2 55
> > Name3 23
> > Name2 65
> >
> > new query:
> > DesignHoursName1 DesignHoursName2 DesignHoursName3
> > 34 55 23
> > 56 65 22
> > 66 36 44
> > 45 25 27
> >
> > I want each field to be sorted by the name associated with those Design
> > Hours. So basically I want each field to be based on two field from the
> > table and then output to the new query.
> >
> > "KARL DEWEY" wrote:
> >
> > > Substitute your table name for Customer.
> > >
> > > SELECT Customer.Area, Sum(Customer.Design_Hours) AS SumOfDesign_Hours
> > > FROM Customer
> > > GROUP BY Customer.Area;
> > >
> > >
> > > "Kwgame" wrote:
> > >
> > > > I am creating a database for my job that deals with getting information about
> > > > workload in different areas. What I want to do is bar chart the information
> > > > in way that would compare each area but what I need to do first is create a
> > > > query that has each area listed so I can chart each individual field. The
> > > > comparison all comes from one field (Design Hours) which is located in my
> > > > table and I need to come up with a new query that will divide the Design Hour
> > > > field into three different areas. So to sum up what I want, basically I want
> > > > to filter out the Design Hours field from the table and then in the query
> > > > have Area1 field and the design hours for that area, Area2 field and the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11929
> > > > design hours for that area, and Area3 field and the design hours for that
> > > > area. I am an intern and I am extremely new to access, this is my first
> > > > database so can anyone help me please!!!!

#9 (**permalink**) 28-Jul-2006, 08:25 AM

If you are unwilling to provide the sample data and table structure as I
asked I can not help you.

"Kwgame" wrote:

> What I really want to do is compare the hours for 4 different groups in a
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11929
> chart format and to do this I have to make a query with the 4 different group
> hours since I cannot take the DesignHour coloumn from four different query or
> I get a message
> that says I can't take fields from a table and a query based on a table.
> Access really sucks when it comes to graphing!!
>
> "KARL DEWEY" wrote:
>
> > This will give you one row in the results.
> > TRANSFORM Sum(Kwgame.DesignHours) AS SumOfDesignHours
> > SELECT Kwgame.x
> > FROM Kwgame
> > GROUP BY Kwgame.x
> > PIVOT Kwgame.UserContact;
> >
> > Your results example shows four rows. What would make the output contain
> > four rows?
> >
> > It would be a whole lot easier and less time consumming if you posted your
> > table structure and a sample of data like Wolfgang suggested.
> >
> > "Kwgame" wrote:
> >
> > > Here is a little more help with showing you what I want.
> > > from table:
> > > UserContact DesignHours
> > > Name1 34
> > > Name1 56
> > > Name2 55
> > > Name3 23
> > > Name2 65
> > >
> > > new query:
> > > DesignHoursName1 DesignHoursName2 DesignHoursName3
> > > 34 55 23
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11929
> > > 56 65 22
> > > 66 36 44
> > > 45 25 27
> > >
> > > I want each field to be sorted by the name associated with those Design
> > > Hours. So basically I want each field to be based on two field from the
> > > table and then output to the new query.
> > >
> > > "KARL DEWEY" wrote:
> > >
> > > > Substitute your table name for Customer.
> > > >
> > > > SELECT Customer.Area, Sum(Customer.Design_Hours) AS SumOfDesign_Hours
> > > > FROM Customer
> > > > GROUP BY Customer.Area;
> > > >
> > > >
> > > > "Kwgame" wrote:
> > > >
> > > > > I am creating a database for my job that deals with getting information about
> > > > > workload in different areas. What I want to do is bar chart the information
> > > > > in way that would compare each area but what I need to do first is create a
> > > > > query that has each area listed so I can chart each individual field. The
> > > > > comparison all comes from one field (Design Hours) which is located in my
> > > > > table and I need to come up with a new query that will divide the Design Hour
> > > > > field into three different areas. So to sum up what I want, basically I want
> > > > > to filter out the Design Hours field from the table and then in the query
> > > > > have Area1 field and the design hours for that area, Area2 field and the
> > > > > design hours for that area, and Area3 field and the design hours for that
> > > > > area. I am an intern and I am extremely new to access, this is my first
> > > > > database so can anyone help me please!!!!