Results 1 to 4 of 4
  1. #1
    raffi is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    Inside a Sub Procedure
    Posts
    88

    lower then 0 do not show


    hello i have a query which has a qty field showing quantities of transactions and etc.

    much like the <> 0 which will eliminate all 0's is there a macro which eliminates everything below 0 which i can place it in the criteria ? in other words every digit which has the minus sign like -1 -2 -3 to cancel out all those

    thank you !

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,441
    < 0 - less than zero
    <= - less than or equal to zero

  3. #3
    raffi is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    Inside a Sub Procedure
    Posts
    88
    well it worked i just set >=0 lol it looks like an angry face

  4. #4
    raffi is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    Inside a Sub Procedure
    Posts
    88
    well it was actually >0 what im looking for but thx for the help

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

Similar Threads

  1. Replies: 2
    Last Post: 04-25-2014, 11:09 AM
  2. Replies: 5
    Last Post: 10-23-2012, 03:55 PM
  3. Replies: 3
    Last Post: 08-22-2012, 09:01 AM
  4. Upper & Lower Case in table
    By Forums10 in forum Access
    Replies: 4
    Last Post: 01-31-2011, 09:01 AM
  5. Converting all text input to lower case
    By aommaster in forum Forms
    Replies: 6
    Last Post: 08-05-2009, 05:43 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