Results 1 to 5 of 5
  1. #1
    brigitteAT is offline Advanced Beginner
    Windows 7 64bit Access 2013 64bit
    Join Date
    Jan 2021
    Posts
    61

    Question don't want to show 0-Values in Report

    I tried to find out, what I have to do, so that 0-Values don't show up in reports...


    so far I have neither found the right place in the report nor in the field where I should define that...

    only found two hints about "formatting" in www but don't know where to add this information!?!?!
    (FJSOLLbrutto.Visible = Not FJSOLLbrutto = 0 .... or # ????????)

    the report in which I don't want to see 0-Values is called : Kontobisher
    one of the fields I want to hide, if it is 0, is called: FJSOLLbrutto

    Win7pro, Acess 2013

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    AND OR NOT are boolean comparison operators. Unless grouped their order of application can be something other than what you think is going on, plus IIRC they don't all take the same order of precedence. In other words wrt FJSOLLbrutto.Visible = Not FJSOLLbrutto = 0, which is being evaluated first?
    FJSOLLbrutto.Visible = Not FJSOLLbrutto and then =0 ?
    or
    Not FJSOLLbrutto = 0 then FJSOLLbrutto.Visible = ? I don't try to remember so I can't answer for this specific case. Try a grouping that matches what you expect; e.g.

    FJSOLLbrutto.Visible = Not (FJSOLLbrutto = 0) or whatever it is you're after. Also, if a table field defaults to 0 and you create a record and omit a value, the report will show 0. You might have also put 0 as a default on the control itself (not sure if a report will exhibit the same behaviour as a form wrt control default value property). Not possible to pinpoint the issue with the limited info you provided.
    Last edited by Micron; 01-19-2021 at 04:40 PM. Reason: clarification
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    always helps to provide some example data. sounds like you have a record displaying say six fields

    1..2..3..0..3..2

    and you want to see

    1..2..3.. ..3..2

    if so then use the format property of each control

    only found two hints about "formatting" in www but don't know where to add this information!?!?!
    the control format property. For numbers you set formats based on positive, negative, zero and null separated with a semi colon e.g. for the example above for each control put

    0;0;"";""

  4. #4
    ssanfu is offline Master of Nothing
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    You could use a custom number format in the control on the report. See Number and Currency data types (Format property)

    Look for the heading Custom formats and below the EXAMPLES header, look for The following are examples of custom number formats

  5. #5
    brigitteAT is offline Advanced Beginner
    Windows 7 64bit Access 2013 64bit
    Join Date
    Jan 2021
    Posts
    61
    great!!! thank you so much, the solution for my report seems to work with: #;#;"";""
    it looks much better/clearer , when I print out the account reports with only the necessary data!!! :-):-)

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

Similar Threads

  1. Show Values
    By Eranka in forum Access
    Replies: 8
    Last Post: 02-20-2019, 10:38 PM
  2. Show Values Once
    By Eranka in forum Access
    Replies: 1
    Last Post: 02-15-2018, 09:52 PM
  3. Trying to show only Non Null Values on a report
    By adamtate94 in forum Reports
    Replies: 7
    Last Post: 09-07-2016, 10:09 AM
  4. Replies: 3
    Last Post: 05-08-2014, 10:25 AM
  5. Only show numeric values
    By dr4ke in forum Queries
    Replies: 2
    Last Post: 07-22-2012, 05:09 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