Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005

    Unanswered: Binding Report to Another Query

    I currently have a report that is bound to a Query. I copied and pasted the report to create an identical one. It is still bound to the original query. Is there any way to bind that report to a different query? The format of the other query is exactly the same.

    Access 2000 gives you option to select which query you would like a report bound to when creating a new report. I am basically asking if this parameter can be modified once a report already exists?

    Thanks for your help!

  2. #2
    Join Date
    Jun 2004
    Florida, US
    you can choose another query from report's recordsource property.

  3. #3
    Join Date
    Sep 2004
    Tampa, FL
    Hello, Welcome to the board.
    Since your post is the first and it sounds like yiou are rather new to Access (since you are using the report wizard from your description) I will expand the reply from Ghozy a bit.
    Right Click on the black square in the upper left of the report in design view. Select Properties. Select the Data tab. Choose your query from the record source drop down.
    Lastly ( at the risk of sounding sarcastic) Read the help files and consider buying a decent DB book.

Posting Permissions

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