Results 1 to 2 of 2
  1. #1
    ICBSprod's Avatar
    ICBSprod is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Jan 2014
    Location
    Norway
    Posts
    10

    Parameter accept several values

    Hi!
    I want my parameter to accept one, several or a range of values.
    The same way you will print out one, several specific pages, or a range of pages from a large document.

    In this case I want the result to show me one specific week, ex: 4, several weeks, ex: 2,5 (or more), or a range of weeks, ex: 10-16.
    How do I set up the criteria?



    Best regards
    Børge

  2. #2
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    That's not easy, you would have to create the query in VBA, as you would have to use different actual criteria depending on what the user entered.

    The simplest route would be to use IN() in the criteria, but your users would have to type in comma separated values.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

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

Similar Threads

  1. Get Rid of Enter Parameter Values
    By rpraveen6r in forum Queries
    Replies: 2
    Last Post: 07-12-2016, 08:00 AM
  2. Replies: 3
    Last Post: 03-04-2016, 10:36 AM
  3. Parameter Query with several values
    By Zalina in forum Access
    Replies: 3
    Last Post: 12-15-2014, 07:18 AM
  4. Only accept values from the combobox.
    By athyeh in forum Programming
    Replies: 4
    Last Post: 01-13-2014, 05:34 PM
  5. Parameter Values
    By Darkladymelz in forum Queries
    Replies: 12
    Last Post: 01-19-2012, 08:45 AM

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