Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2013

    Unanswered: count crosstab query

    hello all,

    I have a query which has the following columns [subsno] [amount billed] [date]

    I'm having trouble figuring SQL syntax on how to do a crosstab query where the column headings would be the date, the rows would be the amount billed and the values would be a count of that billed amount in a particular month(date).

    Any help would be greatly appreciated! Thanks


    okay so I figured out the basics of the syntax:
    transform count([amount billed])
    select [amount billed]
    from total_billed_bygroup
    group by [amount billed]
    pivot [date];

    Also, how can I make the query only give me dates past a specified point. For example everything past 12/2010

    note: dates are in this form: 12/2010 would be 21012

    thanks again
    Last edited by mmongo; 03-01-13 at 15:47.

  2. #2
    Join Date
    Feb 2013
    Ignore this post. Figured it out. Sorry

Posting Permissions

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