Results 1 to 6 of 6
  1. #1
    Mike Cooper is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Apr 2006
    Location
    Europe
    Posts
    6

    Creating multiple reports from one Query

    Hi

    i'm trying to creat 3 multiple reports using one query and using the same paramters

    e.g Enter Start Date = 01/04/06
    Enter end Date = 30/04/06

    I don't want to enter the above information in again for each report.
    Can it be possible to enter the parameters once than all 3 report are then printed from a macro

    Thanks

  2. #2
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Posts
    99
    Create a form with 2 date fields and have the query reference the form fields, like this:

    Select * From [MyTable] WHERE [DateTran] Between [Forms]![MyForm]![FromDate] And [Forms]![MyForm]![ToDate]

  3. #3
    Mike Cooper is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Apr 2006
    Location
    Europe
    Posts
    6

    Multiple reports from one query

    Thanks SetUP for the quick reply,

    still on a learning curve how do I tell each report the
    "Select * From [MyTable] WHERE [DateTran] Between [Forms]![MyForm]![FromDate] And [Forms]![MyForm]![ToDate]"
    I think i know what you mean

    Do I do this in each reports query ?

    Thanks

    Mike

  4. #4
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Posts
    99
    I thought you said you are using the same query for all 3 reports?

    In any case, even if you are using 3 diffrent queries, putting a similar "Where" clause in each query should do the trick.

  5. #5
    Mike Cooper is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Apr 2006
    Location
    Europe
    Posts
    6
    SetUP,


    Thanks it worked .
    Can you use the same method for Charts ?

    Thanks again SetUP

    Regards

    Mike

  6. #6
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Posts
    99
    Sure, don't see why not.

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

Similar Threads

  1. Replies: 1
    Last Post: 03-23-2010, 04:01 PM
  2. Creating Watermark in Access Reports / Forms
    By Alex Motilal in forum Reports
    Replies: 0
    Last Post: 11-21-2008, 07:11 AM
  3. Creating INT function within a Query
    By LCorrieri in forum Queries
    Replies: 3
    Last Post: 01-25-2008, 10:38 AM
  4. Replies: 0
    Last Post: 02-14-2007, 01:35 PM
  5. Form that runs query and creates reports
    By Valeda in forum Forms
    Replies: 2
    Last Post: 05-04-2006, 07:01 AM

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