Results 1 to 4 of 4
  1. #1
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Adding to Report (XP)

    My mind seems to have turned into swiss cheese. <img src=/S/nope.gif border=0 alt=nope width=15 height=15> A nudge would help.

    I have a report that someone else created. I need to add data to it from another query. I have forgotten how to bind the new query to the report.

    All this switching gears from Excel VBA to Access is giving me a headache.
    Alan

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Adding to Report (XP)

    You're looking for the Record Source property of the report as a whole. It is in the Data tab of the Properties window.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Adding to Report (XP)

    A little more information please. If you want to add the query to the recordsource of the report, just join it to whatever table or query is already the source for the report. If it's a table, create a new query and join the table and the query together. If you need a subreport, just bind the subreport to the query and then link the subreport to the parent using the Master/Child link fields.
    Charlotte

  4. #4
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Re: Adding to Report (XP)

    The person who originally created the report made a Total Discounts row. The customer now want to see the detail. Looks like I need to go back to the original query and add to it.

    Their naming convention left a lot to be desired (queries are named exactly the same as the reports) and no reports reuse queries.
    Alan

Posting Permissions

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