Results 1 to 2 of 2

Thread: Report Question

  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Louisville, Kentucky, USA
    Thanked 0 Times in 0 Posts

    Report Question

    Hello Everyone,

    I need HELP resolving this issue and was hoping someone would offer some ideas.

    I have 3 tables...1)tTime, 2)Projects and 3)Budgets. In tTime, there are many fields one of which WeekEndingDate another one is Department, etc... In Department there is only 1 field ... that field contains a list of 15 different departments.

    My query joins all 3 tables with the critera being specified projects with specified WEDates (all Friday dates) and returns:

    the projects which had time spent for the specified period grouped by the department.

    My problem is that if a project had time spent on it say, Department1 didn't spend any time, Department2 didn't spend any time, but Department3-15 did, it will show Department 3-15, I need it to show 1 and 2 as well but since these departments didn't spend any time, I would like it to show 0. Can this be done?

    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Indianapolis, Indiana, USA
    Thanked 0 Times in 0 Posts

    Re: Report Question

    Hi Roberta,

    It sounds like you need to modify the join properties of the Department table in your query. Just double-click on the Relationship line between your Department table and the other table that it's linked to. You'll see the "Join Properties" dialog box. From there you can choose (1,2, or 3) to Show ALL records from the Departments table. Access 2000 gives you a few more options to play with than 97, but basically the concept is the same. Once you've told it to show ALL records in the Department table you'll see all departments.

    If the value for the unused Departments shows as Null, you may want to use the NZ() function as an expression on the Department column in the query: =NZ([DepartmentID])

    HTH <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

Posting Permissions

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