Problem filtering reports

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.
 
D

Duane Hookom

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering problem 1
Reports that sift records from different tables 0
Passing values between reports 1
Filtering subreports on main report 0
Multiple Reports – Same Query – Underlying Data Changes Frequently 1
filtering for reports 1
Missing data in Access reports 6
Multiple Reports – Same Query – Underlying Data Changes Frequently 3

Top