Results 1 to 2 of 2
  1. #1
    emily at KU Guest

    How do I hide inactive records when creating a report in Acc

    I have a database of student employees. A co-worker of mine needs a list of
    the employees by room number. I have created a report for her, but I want to

    hide the records of inactive employees, and I can't figure out how to do
    this. I don't want to delete them from the system, yet I don't want them
    showing up in my report.

  2. #2
    Join Date
    Dec 2006
    Create a query that selects the records you want to print (filters out the inactives) and use that query as the data source for your report.


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

Similar Threads

  1. Hide zero value in report and date syntax
    By Alex Motilal in forum Access
    Replies: 0
    Last Post: 11-16-2008, 09:11 AM
  2. creating a report in this manner
    By jiwatramani in forum Reports
    Replies: 1
    Last Post: 11-07-2008, 11:39 PM
  3. Replies: 0
    Last Post: 10-23-2008, 12:08 AM
  4. Creating top values with two records
    By avesamuel in forum Queries
    Replies: 0
    Last Post: 10-15-2007, 10:45 PM
  5. Creating a string from all records in a table
    By ocordero in forum Programming
    Replies: 2
    Last Post: 08-07-2006, 09:21 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