Results 1 to 8 of 8
  1. #1
    Erictsang is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    154

    How to show only the items is not null

    Dear all



    I would like to get help on making a report which show only what the customer's selected items.

    Appreciate your help in advance.

    I tried to use Queries, in the "Or"row input "Is not null" but in vain

    Is that a way i can do that ?Database101.accdb



    Thanks
    Eric

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    There aren't any nulls present. I assume you meant zeros.
    I also assume that you don't want to see a report group for any individual who has all zeros.
    The query below will omit any record with all zeros.
    Code:
    SELECT Master.ID, Master.Reg_date, Master.Reg_Type, [fname] & " " & [lname] AS Name, Master.CountryA, Master.CountryB, Master.Graduate, Master.Pass_A_28Nov, Master.Pass_A_29Nov, Master.Pass_A_30Nov, Master.Pass_B_28Nov, Master.Pass_B_29Nov, Master.Pass_B_30Nov
    FROM Master
    WHERE (((Master.CountryA)>0)) OR (((Master.CountryB)>0)) OR (((Master.Graduate)>0)) OR (((Master.Pass_A_28Nov)>0)) OR (((Master.Pass_A_29Nov)>0)) OR (((Master.Pass_A_30Nov)>0)) OR (((Master.Pass_B_28Nov)>0)) OR (((Master.Pass_B_29Nov)>0)) OR (((Master.Pass_B_30Nov)>0));

  3. #3
    Erictsang is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    154
    Davegri

    Thanks but it is not working
    I copy to the "SQL view " in Query

    I hope i can make the report for my user and show to them what they have
    selected .

    In report,i apply the Can Shrink function but it is not working
    Also the Text Box can not be shrinked

    It really rack my brian and i hope anyone would help to resolve this problem

    or if there is any code can help

    Thanks

  4. #4
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    I hope i can make the report for my user and show to them what they have
    selected .
    Don't understand. The example you posted has no way for a user to select anything. There's no form, just a table, a query and a report.
    It's unclear exactly what you want.

  5. #5
    Erictsang is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    154
    I have skipped the form. use the table to create the form for input

    Query to filter the data that i want for a report.

    So, the table is the collection of the data . Some is Zero and some is 1.
    1 is what they select, Zero is no selection made

    Eric
    Attached Files Attached Files
    Last edited by Erictsang; 10-08-2017 at 09:18 AM. Reason: update

  6. #6
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    1 is what they select, Zero is no selection made
    And how would you like to see this in the report that is different from the current report?

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    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.

  8. #8
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Your table is laid out as a spreadsheet. Database layout is another matter. You will not be able to get the report that you want without another table that lists the individual '1' items vertically for each individual person. This new table needs to be linked to the individual person's table in a classic one-to-many relationship.
    Last edited by davegri; 10-08-2017 at 01:25 PM. Reason: clarif

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

Similar Threads

  1. Replies: 4
    Last Post: 03-11-2017, 09:48 PM
  2. Replies: 2
    Last Post: 09-18-2015, 02:22 PM
  3. Query to return blank or null items.
    By mulefeathers in forum Queries
    Replies: 3
    Last Post: 10-24-2013, 12:45 PM
  4. Replies: 5
    Last Post: 10-28-2012, 03:26 AM
  5. Replies: 0
    Last Post: 12-14-2009, 04:55 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