Re: A vs B query?

It would help if you posted the SQL of your query.

Simple example with generic names

SELECT Shift
, Sum(IIF(HourType="Direct",Hours,Null)) as DirectHours
, Sum(IIF(HourType="InDirect",Hours,Null)) as InDirectHours
FROM YourTable
GROUP BY Shift

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"jlillge" <jlillge@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5BF992B2-C6D1-40A2-82A7-0D51C59FC5F0@xxxxxxxxxxxxxxxx
I'm not even sure if a query is the right way to go about finding my
answer,
so I could use some direction.

I have one table with about 10 columns and around 100,000 rows of data.
The
data covers hours worked by employees, what shift, what machine, and what
department, and whether the hours were direct or indirect to product
manufacturing.

What I want to do is create some "sums" to compare the hours that were
direct vs. indirect in each of the categories. I am able to create, for
example, a query that displays all the hours per shift that were direct
(by
telling the query to remove the codes for indirect work from the results
data). But is there a way to include another row that will display the
opposite of that data - only the indirect codes without the direct ones?
Or
do I have to have two separate queries for each sum/total? Is there any
way
to get the direct and indirect amounts to display side-by-side, such as in
a
report or something?

Thanks,
Jessa
--
Jessa Lillge


.

Relevant Pages

  • Re: A vs B query?
    ... Jessa Lillge ... You could convert this to a Crosstab query and include the Charge_Type as ... the Column header, Shift as a Row header, and as a Value ... direct vs. indirect in each of the categories. ...
    (microsoft.public.access.queries)
  • Re: A vs B query?
    ... You could convert this to a Crosstab query and include the Charge_Type as ... the Column header, Shift as a Row header, and as a Value ... direct vs. indirect in each of the categories. ... But is there a way to include another row that will display the ...
    (microsoft.public.access.queries)
  • Re: A vs B query?
    ... My SQL to get me the sum of all Direct hours by shift: ... Jessa Lillge ... direct vs. indirect in each of the categories. ... telling the query to remove the codes for indirect work from the results ...
    (microsoft.public.access.queries)
  • Re: A vs B query?
    ... ,NULL,) as InDirect ... You could convert this to a Crosstab query and include the Charge_Type as ... the Column header, Shift as a Row header, and as a Value ... opposite of that data - only the indirect codes without the direct ...
    (microsoft.public.access.queries)
  • Undefined value error
    ... with the following code I can successfully query a datasource and ... display the results in html. ... successfully defined and the query works. ... $office_code = shift; ...
    (perl.dbi.users)