Results 1 to 2 of 2

I need to create a query that shows all the copies of some record even if it is checked out

  1. #1
    Mahnoor is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Posts
    3

    I need to create a query that shows all the copies of some record even if it is checked out

    Hello,



    I need to create a query that shows all the copies of a particular work (the number of copies are 23) even if the work is checked out by somebody, and if so, then by whom. As soon as I add the fields of date out and name, the query result is reduced to 3 instead of 23. I don't know what to put in the criteria so that I get the desired result of 23 records in the work field and 3 records in the check out field.

    Thanks in advance

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,871
    You can select the two fields without making them part of the selection criteria.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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

Similar Threads

  1. Checkbox Always Shows Checked
    By jo15765 in forum Forms
    Replies: 3
    Last Post: 08-16-2016, 05:58 AM
  2. Replies: 9
    Last Post: 03-15-2015, 09:37 PM
  3. Replies: 5
    Last Post: 10-10-2014, 02:07 PM
  4. Replies: 2
    Last Post: 03-08-2014, 01:45 AM
  5. Replies: 1
    Last Post: 03-08-2012, 08:17 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
  •  
Tech Forums: Microsoft Office Forums