Results 1 to 2 of 2

Thread: Report question

  1. #1
    Join Date
    Sep 2005

    Unanswered: Report question

    I have a subreport in my main report that adds up the days left for vacation. I would like the report to show just the employees that have not used all there vacation yet. Otherwise anyone where this number is greater than 0. I use access rarely and have not worked with it much, especially in this aspect, what would I have to do to view this info. Access 2003, thanks in advance.

  2. #2
    Join Date
    Apr 2004
    outside the rim
    Use a query to total the remaining vacation days and set one of the criteria to ">0". Base the report on the query.
    have fun!

    Todd S.
    click to email

    Independent Development Consultant
    Biz db & reports - SQL, Access, Crystal, Seradex and more
    Small, custom, unique programs - Office, VBA, .NET

    Favorite message from Windows:
    There was an error displaying the previous error message

    Sadly, there was no error number to look up ...

Posting Permissions

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