Results 1 to 5 of 5
  1. #1
    b3nb123 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    9

    Report, listing ONLY those with a certain field not empty

    I'm trying to generate a report, listing all the clients in a certain table, leaving out all those who's 'Package Total' field is blank.


    So my report is a list of only those clients who have something in that field (Only confirmed clients have anything in that field, so it only lists confirmed clients and not enquiries)
    And I'd like the bottom of the report to show a sum of All the 'Package Total' fields added together.

    I'm really new to this. I've managed to use the report wizard to show a columnar view, but right now it's showing every entry in my table, I'd like to know how to filter it to leave out those with that field blank.
    All Google results I've found tell me to add entries to the 'Filter' entry under properties, but I can't see one!

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    ?you cannot set the query field to: [Package Total] is not null

    or make a query,Q1
    all ClientID where field is null

    make another query, join Q1 to the table and pull the items NOT listed in Q1

  3. #3
    b3nb123 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    9
    Thanks for your reply, however, embarrassingly I've got no idea even how to make a query! All I've managed to do in Access is import an excel table, and create a form to display it. I'm quite proud of myself for that, but that's literally the limit of my Access knowledge!

  4. #4
    dashiellx's Avatar
    dashiellx is offline Falconer
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Location
    Baltimore
    Posts
    49
    Try the query wizard on the create tab:


  5. #5
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    This is basic Access 101.
    queries are the backbone of Access.

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

Similar Threads

  1. Replies: 2
    Last Post: 08-14-2014, 06:26 AM
  2. Replies: 4
    Last Post: 12-12-2013, 09:13 PM
  3. Replies: 6
    Last Post: 03-27-2013, 05:45 PM
  4. Replies: 3
    Last Post: 03-23-2012, 06:16 AM
  5. Listing correct data in a field
    By Lois in forum Forms
    Replies: 1
    Last Post: 10-18-2011, 12:09 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