Re: Crosstab query

On May 28, 12:24 pm, KARL DEWEY <KARLDE...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
This should do it.  Add more fields for the rest of your priorities.
SELECT Sum(IIF([Priority]="A",1,0)) AS [Priority A],
Sum(IIF([Priority]="B",1,0)) AS [Priority B],
Sum(IIF([Priority]="C",1,0)) AS [Priority C]
FROM [tblJobs];

Add criteria as needed.
--
KARL DEWEY
Build a little - Test a little



"rama" wrote:
Hello
I am looking for some help to finish my access report.
In my access database I got table called tblJobs. There are some
fields - Date, Job, Priority etc. Each Job will have a Priority and it
can be 'A' or 'B' or 'C'. In my date wise report I wanted to summaries
the Priority like how many A, How many B, How many C etc. For that I
run a Crosstab query and the query runs fine. But now I am unable to
pull this single row data from Crosstab query to my report. Or is
there some other way to summaries the priority to a single line.
Rama- Hide quoted text -

- Show quoted text -

Thanks a lot for the help. Exactly this is what I was trying for.
Rama.
.

Relevant Pages

  • Crosstab query
    ... I am looking for some help to finish my access report. ... Each Job will have a Priority and it ... pull this single row data from Crosstab query to my report. ...
    (microsoft.public.access.formscoding)
  • RE: Crosstab query
    ... I am looking for some help to finish my access report. ... Each Job will have a Priority and it ... pull this single row data from Crosstab query to my report. ...
    (microsoft.public.access.formscoding)
  • Report Identifies Top Priorities for Astronomy in the Coming Decade
    ... REPORT IDENTIFIES TOP PRIORITIES FOR ASTRONOMY ... priority research activities for astronomy and astrophysics in the ... next decade that will "set the nation firmly on the path to answering ...
    (sci.space.news)
  • Re: defining criteria for a report
    ... Presumably the report is based on a table or query that has a field named ... Priority field has one of the values in the list box. ... > just trying to get the listbox for priority to work ... Dim varItem As Variant ...
    (microsoft.public.access.reports)
  • Re: vms base priority watch
    ... increase in a user's base priority would aid its completion time. ... report, that could impact the completion time. ...
    (comp.os.vms)