Results 1 to 3 of 3
  1. #1
    timo1999 is offline Novice
    Windows XP Access 97
    Join Date
    Aug 2009
    Location
    Houston
    Posts
    12

    How do I use a MODULE in a Cross-Tab Query?

    I have a VBA code saved in a MODULE that David was so kind to create for me. However, I don't know the procedure to applying the module in a cross-tab query. All I know how to do is open a crosstab query in design mode and then ????



    The directions I got were for using a crosstab query as follows:

    Row Heading: PriceGrouper ([UMRC])
    Column Heading: FractionGrouper (ConvertFraction([UMRP]))
    Group by row heading

    Any help would be great

    Tim

  2. #2
    llkhoutx is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    You have it backwards, a crosstab query does not have a module. One could create and/or execute a crosstab query in a module. Why can't you create your crosstab query with the query wizard? I'm confused with your question.

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Are you cleaning up all the 5-8 year old threads?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Cross Tab Query
    By nengster in forum Queries
    Replies: 0
    Last Post: 02-18-2009, 07:12 PM
  2. Adding rows on cross-tab query report
    By KahluaFawn in forum Reports
    Replies: 2
    Last Post: 02-18-2009, 10:09 AM
  3. access cross tab query
    By Hossam in forum Access
    Replies: 0
    Last Post: 11-10-2008, 06:01 AM
  4. Multiple cross-references from one record
    By bpkcjgorr in forum Database Design
    Replies: 0
    Last Post: 01-03-2008, 02:33 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