Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2014
    Posts
    2

    Unanswered: Report Filtering

    I have created a database that has several reports that categorize records based on specific values. Everything works great with the exception that at the bottom of this report it compiles all the remaining records (those without a selected value) as a category as well. Can someone please provide me with a good solution for removing the category that contains these unspecified values? Thanks in advance for any advice!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    how have you defined the the 'compilation' of remaining records?
    Access reports work on queries or domain functions.

    my guess is you are using a domain function such as DSUM, DCOUNT etc and if so you need to apply the filter to those domain functions
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Apr 2014
    Posts
    2
    Quote Originally Posted by healdem View Post
    how have you defined the the 'compilation' of remaining records?
    Access reports work on queries or domain functions.

    my guess is you are using a domain function such as DSUM, DCOUNT etc and if so you need to apply the filter to those domain functions
    Im actually using queries. Im not sure how to set the query to leave out records that equal blank. I can accomplish it as a filter within the actual query but this does not save to the query as it is a temporary filter.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •