Crosstab Query?-NOT BLANK

Sorry for the previous blank post, finger slipped. Hi there, I am having
trouble designing a query to bring the following information so I can put it
all on one report (I'm not opposed to using subreports): Number of PM's
issued by month, no. of issued PM's for month completed in month, and the #
of previously issued PM's completed within that month.My fields are: Tbl
PMLog
PMOrderID StartDate DateCompleted (The StartDate is the issue date)
What kind of query would I use, and if it is a crosstab, how do I set it up?
I have never used them. Thanks so much in advance!
--
Aaron Regular, Dissent Records
www dot nbtnc dot com


.

Relevant Pages

  • RE: Crosstab Query?-NOT BLANK
    ... > trouble designing a query to bring the following information so I can put it ... > Aaron Regular, Dissent Records ... > www dot nbtnc dot com ...
    (microsoft.public.access.queries)
  • Re: TWO Crosstab Query Ouput Questions
    ... field very similar to the LOCATE field in the STATES2 that we created. ... I was certain that all I had to do was create a crosstab on RCROSS with RLOC ... do is to modify the main query to change your RFLY_RSTA to LOCATE and the ... locations for each species as rows with the ...
    (microsoft.public.access.queries)
  • Re: TWO Crosstab Query Ouput Questions
    ... we want to see and use those as the input to the crosstab. ... and only 1098 in the final query. ... locations for each species as rows with the ... concerning the Totals Query. ...
    (microsoft.public.access.queries)
  • Re: dynamic crosstab A2002 - Almost there
    ... I would set up the crosstab as ... Query 1: QryMonthlyIncidentsBase_Crosstab ... Base your report on this query. ... >>> Dim ReportLabelAs String ...
    (microsoft.public.access.queries)
  • Re: Cross Tab Query with two value=-[Result] & " - " & [Error] as the
    ... This solution uses a crosstab with a cartesian to create multiple values. ... Anyway, the Union Query now has 6 SELECT parts, not 3, and each one ... SELECT ID,Client,Date, ResultA as Value1, "ResultA" as Task ...
    (microsoft.public.access.queries)