Results 1 to 3 of 3
  1. #1
    justifiedcandy is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2010
    Posts
    6

    Display all results if parameter is blank

    Hi-
    I'm trying to create a query on a column with only numbers. When I leave the parameter blank, no results show. I would like all results to show if the parameter is left blank. This is the code I'm using:

    Between [Minimum Number] And [Maximum Number]



    Thanks!

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    (fieldName >=[Minimum Number] or [minimum number] is null ) And (fieldname<=[Maximum Number] or [maximum number] is null)

  3. #3
    justifiedcandy is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2010
    Posts
    6
    thanks, works!

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

Similar Threads

  1. Display Query Value That Requires Input Parameter
    By Access::Student in forum Access
    Replies: 1
    Last Post: 05-29-2009, 08:43 PM
  2. Form to display results
    By Zholt in forum Forms
    Replies: 9
    Last Post: 05-07-2009, 10:09 AM
  3. Replies: 6
    Last Post: 02-20-2009, 11:50 AM
  4. Replies: 3
    Last Post: 10-23-2008, 08:43 AM
  5. Replies: 4
    Last Post: 01-05-2006, 02:36 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
  •  
Other Forums: Microsoft Office Forums