Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    May 2003
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report field null (Access 2000)

    I have a report that is based on a parameter query. The report is a list of employees and pager numbers for being "on call".

    The query gives me the names of employees based on the core group they are in. In this case the core group is NICU. If I type in NICU when prompted, I get all the employees. My problem is, there are 3 people in this group who do not take call and they do not have pager numbers. I don't want them on the list, is there any way to filter them out on the report or do I have to make another query?

    Thanks,
    Linda

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report field null (Access 2000)

    In the query grid under the field for the pager number field put Is Not Null as a criteria.

  3. #3
    New Lounger
    Join Date
    May 2003
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report field null (Access 2000)

    Thanks, Preston. I use that query for other reports but if I don't have that field in the other reports will it effect them at all? I guess I thought it might. I can't test it until tomorrow when I go back to work. I'll let you know how it works.

  4. #4
    New Lounger
    Join Date
    May 2003
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report field null (Access 2000)

    Didn't get to play with my database today....those darn doctors kept ordering my services.

  5. #5
    New Lounger
    Join Date
    May 2003
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report field null (Access 2000)

    Sorry this is so late. That worked perfect! Thanks, Preston

Posting Permissions

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