Results 1 to 2 of 2
  1. #1
    tfbalogh is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2017
    Location
    Southeastern PA
    Posts
    8

    Question Report prompt for a list of values

    How do I create a prompt that will allow the user to enter a list of values to be used in the search criteria for a report? Example; I want all of the records for members whose Member Numbers are 009, 101 and 223. But, I want the user running the report to enter the Member Numbers. I don't want to hard-code the Member Numbers into the report query using the IN ("009","101","223") operator.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    use a table to enter the values, (like) tPicked.
    the query joins this table to the main data table and only those values will return.

    or you could even use a form for user to dbl-click the items:

    Click image for larger version. 

Name:	pick state lbls.png 
Views:	10 
Size:	27.7 KB 
ID:	41933

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

Similar Threads

  1. List number items in parameter prompt for a Query
    By Kshugerts003 in forum Access
    Replies: 2
    Last Post: 10-07-2019, 08:06 AM
  2. Input prompt values stored into a table.
    By rplum in forum Queries
    Replies: 4
    Last Post: 07-03-2019, 07:43 AM
  3. Replies: 1
    Last Post: 09-01-2015, 01:06 PM
  4. Replies: 2
    Last Post: 02-15-2015, 07:53 AM
  5. Using Like to prompt input of multiple values
    By eskybel in forum Queries
    Replies: 6
    Last Post: 01-16-2013, 03:45 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