Results 1 to 4 of 4

Thread: Building reports

  1. #1
    Member
    Join Date
    Nov 2012
    Posts
    33
    Rep Power
    0

    Building reports

    I'm still working on our church directory, and I need to know (using Access 2007) if there is a way to use the results of two queries in one report?

    Otherwise I'll have a LOT of wasted space. The pages I'm trying to build a report for are for single/widowed members, and the only way I see to build a report is a single column on a single row (that is with one person per row). I'd like to have two persons per row (take up less space, and waste less paper)

    Thanks

  2. #2
    Senior Member alansidman's Avatar
    Join Date
    Apr 2012
    Posts
    125
    Rep Power
    13
    It may be possible by joining the two queries into a new query that becomes the record source for your report. Without more detailed information from you that is the best i can do. Is the information in the two queries coming from the same table? If so, then maybe you really only need one query. Like I said, we need more detailed information.

  3. #3
    Member
    Join Date
    Nov 2012
    Posts
    33
    Rep Power
    0
    If I knew what you needed to know, I'd comply.

    I have ONE table with all the information I need for our members. Name, address, birthdate, anniversary date, names & info of kids, pictures, etc.

    I want to build a report that will display two members per line (as opposed to one member per line.) What else do you need to know?

  4. #4
    Senior Member alansidman's Avatar
    Join Date
    Apr 2012
    Posts
    125
    Rep Power
    13
    With one table, it sounds like you may need to normalize your date into several tables.

    Look at this link to understand what needs to happen. Once you have normalized data, it will be easier to create your needed query which will act as the record source for your report.

    http://sbuweb.tcu.edu/bjones/20263/A...sDB_Design.pdf

Similar Threads

  1. Displaying dates in reports as MM/DD
    By papabill in forum Access Help
    Replies: 1
    Last Post: 02-26-2015, 06:16 AM
  2. Replies: 41
    Last Post: 08-22-2013, 01:05 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
  •