Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Apr 2002
    Location
    Burlington, Washington, USA
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date grouping in Crosstab Queries (2000 (9.0.2720))

    How do you group and sort by dates in a crosstab query?

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Date grouping in Crosstab Queries (2000 (9.0.2720))

    I am not exactly sure I understand your question. Doesn't a crosstab query, in a sense, group and sort the dates by its creation. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    How are you planning on grouping and sorting the dates?
    Regards,

    Gary
    (It's been a while!)

  3. #3
    Lounger
    Join Date
    Apr 2002
    Location
    Burlington, Washington, USA
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date grouping in Crosstab Queries (2000 (9.0.2720))

    I believe I solved by own question. In my crosstab query, I had a date field that I wanted to group by year and month i.e. (2002-05) which I solved by using =Format([TransactionDate],"yyyy-mm"). I was then able to sort this grouped field in the column of my crosstab query by using Sort by Ascending order. It works very well. Thank you for your help.

    Larry

Posting Permissions

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