Results 1 to 3 of 3
  1. #1
    vincentsp is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2015
    Posts
    29

    Only showing the fields with data


    Is there a possibility to only show the fields with data in a querie.
    I have a query with 3 fixed fields that contain standard information out of my form, so far no problem.
    But I also have 15 variable fields in my querie whereof only one contains a number, but the field that contains a number difference every record.
    I would like to run my query only showing my 3 "fixed" fields and the field (out of the 15) with a value in the same position on my query.

    I hope this makes sence

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    Add to your criteria (WHERE clause)

    Code:
    And Not IsNull(field with the number)

  3. #3
    vincentsp is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2015
    Posts
    29
    Thanks a lot!!!

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

Similar Threads

  1. Replies: 3
    Last Post: 12-29-2014, 01:04 PM
  2. Replies: 15
    Last Post: 04-16-2014, 01:15 PM
  3. Replies: 15
    Last Post: 02-13-2014, 04:53 PM
  4. Replies: 3
    Last Post: 06-19-2013, 06:34 PM
  5. Replies: 4
    Last Post: 05-14-2012, 06:10 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