Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Picking up too many records (2002)

    I have succeeded in creating a report with a subreport. <img src=/S/clever.gif border=0 alt=clever width=15 height=15> . The main report consists of the name, department, and mail code of an administrator, along with a message. The subreport is a list of employees in the department that need to have XXX action taken. The problem is, the administrators name is associated with each employee in the query that is the basis for the report. If there are five employees in a department, I'm getting 5 of the same report. I only need the report, with subreport, once for each administrator. I know the solution is going to be laughably simple, but I haven't found it. <img src=/S/frown.gif border=0 alt=frown width=15 height=15>
    Thanks in advance,

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Picking up too many records (2002)

    The employee information should only be in the record source of the subreport, not in the record source of the main report. See if removing the fields relating to the employee from the record source of the report solves your problem. If not, set the Unique Values property to True for the query that is the record source of the main report. If that doesn't help either, we'll have to know more about the record source of the main report and of the subreport.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Picking up too many records (2002)

    Thank you Hans. I built a query for just the administrators and - success! <img src=/S/bullseye.gif border=0 alt=bullseye width=45 height=15>
    The next question is about the filter -- but that will be tomorrow. I'm goin' home.
    Thanks again

Posting Permissions

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