Results 1 to 3 of 3
  1. #1
    Confused132 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jun 2017
    Location
    USA
    Posts
    2

    Two queries one report


    I am new to MS Access and I am trying to create a database. So far everything is going pretty well and have been able to find the few questions that I have had by googling stuff and finding answers that way. However, I have hit a wall on this one. I am trying to create a schedule for maintenance. I have the basic schedule done and am now trying to get anything that needs to be added into the schedule. So a person would go do the scheduled maintenance and while doing that they notice that they also need to do something else. I started with a Schedule table and created a query for the specific fields that I wanted to display. Then I created a second query that uses a filter on a field that is a yes/no field. The filter is set to only allow the rows that are set to yes to be displayed. Here is where I am having the issue, I want both of these to be displayed into a report and cannot get it to work. Like I said at the beginning I am new to MS Access and am looking for whatever advice you all have. Sadly I cannot put screenshots up to explain better what I am trying to do so if this makes no sense let me know and I will come up with a mock file that might do a better job of explaining what I am trying to do.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Not making sense to me. Why would you want both?

    Perhaps you need subreports.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Confused132 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jun 2017
    Location
    USA
    Posts
    2
    I could give that a try, thanks for the suggestion!

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

Similar Threads

  1. How to get a report from queries
    By scurmu in forum Access
    Replies: 6
    Last Post: 07-06-2016, 02:02 AM
  2. Replies: 11
    Last Post: 04-07-2015, 09:15 AM
  3. Two queries in one report
    By victor in forum Programming
    Replies: 1
    Last Post: 08-05-2010, 01:31 AM
  4. Replies: 1
    Last Post: 06-29-2010, 03:40 AM
  5. Replies: 3
    Last Post: 05-21-2010, 03:57 PM

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