Results 1 to 2 of 2
  1. #1
    alsoto is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2009
    Posts
    67

    Report 90 Different Ways - Best Way To Proceed?

    I have a client that wants a report with the ability to run it 90 different ways (see http://www.alsoto.com/screenshot.gif ).

    Can I use one report and pass the parameters using vba? It would also be good if I could insert the title using vba as well.

    Any suggestions?

  2. #2
    thhui is offline Competent Performer
    Windows XP Access 2002 (version 10.0)
    Join Date
    Feb 2009
    Posts
    235
    You can write different queries based on the option you choose
    (90 queries and 90 report format)
    and change the report data source and title or even data content accordingly.

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

Similar Threads

  1. Replies: 1
    Last Post: 02-02-2009, 05:52 AM
  2. Replies: 0
    Last Post: 10-24-2008, 11:20 AM
  3. report prints blank page at end of report
    By darrellx in forum Forms
    Replies: 0
    Last Post: 03-14-2006, 08:51 PM

Tags for this Thread

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