Results 1 to 2 of 2
  1. 06-23-2010, 01:22 PM #1
    NMJones
    NMJones is offline Novice
    Windows 98/ME Access 2007
    Join Date
    Feb 2010
    Posts
    3

    Group by Week in a Crosstab Query

    Is there a way to group by week in a crosstab query?
    Reply With Quote Reply With Quote
  2. 06-24-2010, 04:09 PM #2
    NTC
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    make a preliminary regular query that is grouped by week......then build a crosstab query sourced on the first query...
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. crosstab query criteria
    By Sharron in forum Queries
    Replies: 3
    Last Post: 12-15-2011, 04:31 AM
  2. Query - Crosstab ?
    By rob4465 in forum Access
    Replies: 1
    Last Post: 01-28-2010, 08:41 AM
  3. Parameter in Crosstab Query
    By RandyG in forum Queries
    Replies: 4
    Last Post: 09-30-2009, 06:40 AM
  4. crosstab query calculation
    By rutica in forum Queries
    Replies: 2
    Last Post: 04-28-2009, 09:52 AM
  5. query problem, oppointments for one week
    By keithsrobinson in forum Queries
    Replies: 2
    Last Post: 02-18-2006, 02:28 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums