Results 1 to 6 of 6
  1. #1
    waving is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    May 2019
    Posts
    3

    Filter records using a list


    I would like to filter an Access table in order to retrieve about 50 records that need to be edited. Each record has a unique barcode. Rather than looking up each barcode individually, can I apply a filter based on a list of barcodes so that they are all listed and the rest are filtered out? I understand how to create a query that would list only those records but I cannot edit a query.

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    If you have a list of barcodes that you want, simply import that into a new table, then perform a matching query between your data table and this barcode table, joining on the barcode field, and it will return just the records that you want.

  3. #3
    waving is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    May 2019
    Posts
    3
    But a query doesn't allow me to modify entries. How can I modify an entry in a query table?

  4. #4
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    It should, unless it is not an updateable query.
    Here is a list of reasons that could cause that: http://allenbrowne.com/ser-61.html

    The most likely culprit is that you have a one-to-many situation going on (i.e. one of your tables has duplicates in the barcode column), which is not an updateable query.
    Is that the case?
    If so, which tables has duplicates and why?

  5. #5
    waving is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    May 2019
    Posts
    3
    The join was one-to-many, I changed that and now it and now I can edit it.
    Thanks so much!

  6. #6
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    You are welcome.

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

Similar Threads

  1. Filter Records within a List Box?
    By Bkper087 in forum Access
    Replies: 10
    Last Post: 03-20-2016, 12:26 PM
  2. Replies: 9
    Last Post: 02-24-2015, 11:19 AM
  3. Replies: 1
    Last Post: 01-28-2014, 05:00 PM
  4. Replies: 15
    Last Post: 11-20-2013, 04:30 PM
  5. Replies: 3
    Last Post: 03-25-2010, 12:31 PM

Tags for this Thread

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