Re: Adding stats....

You limit a crosstab query using the same method you limit any query except
you must enter the data types of all parameters. Select Query->Parameters
and enter your criteria parameters and types.
--
Duane Hookom
MS Access MVP

"Cooptoons" <Cooptoons@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:293BDA13-83D3-41EB-8E47-A2FBCD5585F5@xxxxxxxxxxxxxxxx
Thank you very much! Thats works great. I have only one more question. How
do
you limit the query to a certain month or time frame?

Thanks!
Gary

"Duane Hookom" wrote:

Have you tried creating a Crosstab query? The technician is the Row
Heading
and Condition is the Column Heading. Count(Technician) is the Value. You
may
need to enter all possible Conditions into the Column Headings property.

--
Duane Hookom
MS Access MVP

"Cooptoons" <Cooptoons@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:36052812-6FE3-4703-9C1C-AB21592C81D5@xxxxxxxxxxxxxxxx
Is there any way to use a report to add up different phrases? I use
Access
to
keep track of our repairs. I would like to make a monthly report that
would
would tell me by technician how parts are good, bad or awaiting parts,
and
what was done to repair a part.

I would like something like this:
Good Bad Awaiting Parts No Problem Replaced abc
part
John doe 10 5 7 7
8
John Depp 12 8 2 3
9

In the database good, bad, awaiting parts is stored in the condiction
field.
So i need a way to add up how many times good or bad is in that column
for
a
certain technician.

I hope this explaination is clear....please help.

Thanks
Gary





.

Relevant Pages

  • Re: Corstabquery or normal query
    ... the Column Heading, and first of the name field as the value. ... H. Frank Situmorang ... instruction a while back to "Use the CountOfBidangPelayanan as the the Column ... This is my SQL for Query: ...
    (microsoft.public.access.reports)
  • Re: reserved error -1524 access 2007
    ... OT and cod are the same type ... If OT is a query, ... difficult to trace what's going on without details of the field types. ... It might be that JET is getting the data types mixed up. ...
    (microsoft.public.access.queries)
  • Re: Crosstab Query Question
    ... Don't think I ever tried using multiple Column Heading source fields in one ... > crosstab query for each column heading or are you limited to just one? ... >> You do not want an IN list in the PIVOT clause. ...
    (microsoft.public.access.queries)
  • Re: Query Too Complex
    ... what data types are in use at each level? ... > the grouping levels, however this is by no means ideal. ... > Do you know of anything I can do to make this report run with the number ... >> how to run the query. ...
    (microsoft.public.access.reports)
  • Re: Selecting records using criteria as arguments for a mathematical operation
    ... Show us your query and the data types of the fields involved. ... error message seems to indicate you're doing something that violates ... In the Totals row of the query builder, have you considered changing the Sales column from GroupBy to Sum? ...
    (comp.databases.ms-access)