Problem filtering reports

  • Thread starter Thread starter Lori
  • Start date Start date
L

Lori

Here's the basics. I am running 2003. I have two tables, tblLegalLog and
tblLegalLogDetaisl. They are linked thru an autonumber ID Field.

I have a form set up with four fields, Project#, Responsibility, Business
Unit and Status, which I use to filter the data in a report.

so far so good. The problem is that after working fine for months, there are
two projects that would show up on the base report (the one giving all of the
data) and not show up on any of the 4 optional reports.

I had a similar issue with another set of tables and reports and I ended up
renumbering everything so that the data was fresh. This worked. I tried the
same thing with the Legal Log tables and the only thing that happened was
that instead of project #123456 not working properly, its now project 654321.

I've verified the relationships and everything seems to be fine. I'm stumped
and will take all the help I can get.

thanks.
 
What do you mean by "the 4 optional reports"? Do all of the reports have the
same record source?
 
Back
Top