Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2005
    Posts
    61

    Unanswered: Record count for each month each year

    Hail to All,

    I am needing to add a field to a report that will give a count of how many records were created for each month in each year. I have a report that pulls each record for each month each year. The code that it uses is:

    =Format$([Mailroom Date],"mmmm yyyy",0,0)

    The report works fine and breaks each section down by month and year. But I am needing to add a field to give the count for that month in that year and am not sure on how to do this. Once I have this I am then needing to get a sub count of another field per month.

    Such as the code above gives a list of all mail items for each month in the year. I want to then add the field so show Total mail Items = 50 if thats how many there were for that month then the break down. boxes 10, envelopes 25, deliveries 15.

    Any help is greatly appreciated.

    Mythos

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    what is the SQL for the report?
    Me.Geek = True

  3. #3
    Join Date
    Apr 2005
    Posts
    61

    How do I view the sql for a report?

    how do I reveiw the SQL for the report? the only field that I show data in has this value: =Format$([Mailroom Date],"mmmm yyyy",0,0)

  4. #4
    Join Date
    May 2005
    Posts
    1,191
    So you only have one field that you're reporting? Are you pulling any other fields? From what table are you getting your data?

    what I'm getting at is maybe what you need is similar to this thread.
    Me.Geek = True

  5. #5
    Join Date
    Apr 2005
    Posts
    61

    That will probably do what I am wanting please help

    That will probably do what I am wanting but I can't seem to make it work.
    Ok let me type out what I am wanting. I have two fields and there values.

    [Mailroom Date] [Item received]
    01/01/07 Box
    01/07/07 Envelope
    01/20/07 Box
    02/01/07 Envelope
    02/09/07 Box
    02/15/07 Envelope
    02/18/07 Envelope

    results wanted:

    Date Item Cout of Items
    01/07 Box 2
    Envelope 1

    02/07 Box 1
    Envelope 3

    I just can't get the sql statement to work.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •