Results 1 to 3 of 3
  1. #1
    Derrick T. Davidson is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2013
    Posts
    142

    Show only positive numbers


    Hi I am trying to show only positive numbers in a report, so the report will not show zero or negative values is this possible?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,926
    You want to exclude records where a value is <=0? Use that expression for filter criteria in a query as the report's RecordSource. Or set that filter criteria in the report Filter property.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Derrick T. Davidson is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2013
    Posts
    142
    Huh that was simple thank you

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

Similar Threads

  1. Positive to Negative
    By greek-autumn in forum Queries
    Replies: 3
    Last Post: 03-24-2013, 05:20 PM
  2. Replies: 4
    Last Post: 01-10-2012, 06:26 PM
  3. Replies: 1
    Last Post: 11-29-2011, 08:43 AM
  4. Replies: 2
    Last Post: 09-10-2009, 05:42 AM
  5. Suming Positive Numbers Only
    By jbarrum in forum Access
    Replies: 5
    Last Post: 04-24-2009, 03:51 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