Results 1 to 7 of 7
  1. #1
    JIWAN is offline Novice
    Windows 10 Access 2007
    Join Date
    Oct 2022
    Posts
    2

    Access report only contain value in table


    items uom rate quantity r1 r2 r3 r4 r5
    a ltr 50 100 2 3 5 6 4
    b ltr 25 50 2 3
    c ltr 100 150 5

    sir when i make report of obove table , in report shown item b does not contain value in r3,r4,r5 but can report be generated without contain value .( if in colum does not contain value it should not shown in report )

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Do not understand question.

    What exactly do you not want to show?

    If you want all 3 records on report, how could you not show all columns? If any column (field) has data then the 'column' will show.
    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
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    Use criteria in the query to remove those records.
    Data looks like it is not normalised, so that makes it more difficult to do.

    What about c?, is that meant to be there?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  4. #4
    JIWAN is offline Novice
    Windows 10 Access 2007
    Join Date
    Oct 2022
    Posts
    2
    When i creat report of avobe table than in the report whose column has not value also show in report but i want whose colum has not value it should not show in report.
    In the report show as-
    item = b
    uom = ltr
    rate = 25
    qtr = 50
    r1 = 2
    r2 = 3
    r3=
    r4=
    r5=
    i want that r3 ,r4,r5 has not value it should not show in report

  5. #5
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    We are all struggling to understand the requirement

    you have shown us what your table looks like in post #1

    can you now show (not describe) what you want your report to look like from the data provided

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Are you arranging data in report vertically instead of horizontally?
    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.

  7. #7
    JohnLouisWood is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Mar 2023
    Posts
    52
    Are you printing 1 record at a time, or multiple records?
    My guess is that your text-box will need a conditional statement like =iif(val(nz([r3]))=0,"", "r3 = "&[r3]). This would also involve removing/CUT the attached label, and moving the location of the text box to the left.

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

Similar Threads

  1. Replies: 1
    Last Post: 12-22-2020, 08:17 AM
  2. Replies: 1
    Last Post: 12-14-2018, 01:44 PM
  3. Replies: 6
    Last Post: 07-20-2018, 12:40 PM
  4. Send Report & table as attachment MS access
    By Skhaliq in forum Access
    Replies: 1
    Last Post: 09-19-2015, 10:06 AM
  5. Replies: 10
    Last Post: 11-16-2012, 05:02 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