Results 1 to 2 of 2
  1. #1
    poopatil is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2017
    Posts
    1

    Question How to generate parameterized crosstab query report for dynamic columns ??


    I am new to access in vba..so plz tell me the step by step solution. I am working on attendance sheet. Input to crosstab is month and year (in mmm yyyy format) and the crosstab columns are dates present in that month and year.
    Attached Thumbnails Attached Thumbnails Design view.png  

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    if you look to the bottom of this thread you will find a number of suggestions

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 01-26-2017, 08:29 AM
  2. Dynamic CrossTab Report from Query
    By ZJGMoparman in forum Programming
    Replies: 1
    Last Post: 08-20-2015, 10:54 AM
  3. Open Dynamic Parameterized Query using DAO
    By ItsMe in forum Programming
    Replies: 17
    Last Post: 04-06-2014, 10:57 AM
  4. Dynamic crosstab report sorting headings & dlookup
    By chrisangk in forum Programming
    Replies: 9
    Last Post: 01-14-2013, 02:37 PM
  5. problem with dynamic moving columns in report
    By princeofdumph in forum Reports
    Replies: 1
    Last Post: 12-16-2011, 06:22 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
  •  
Other Forums: Microsoft Office Forums