Filtering problem

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

Lori

I have two tables that are linked together for a report. One is my
tblLegalLog and the second is the tblLegalLogDetails. The first table
provides project numbers, responsibility and location. The second provides
invoicing details for legal invoices. I can very easily run a report that
will give me every project, status and invoice. I also have a filter form to
filter the data based on project number, status, location or responsibility
(all data from the table not a query thru an SQL statement).

Here is my problem.

Two of my entries show up perfectly on the base report (all data) but when I
attempt to filter the data by any of the four available categories, the
fields are blank.

I have an autonumber set up for the LogID that links the two tables, I've
verified that the IDs match and there are no duplicates so I can't figure out
why this is happening. The tblLegalLog only has 129 entries, while the detail
section has less than 1000.

This happened on a different pair of tables in the database and I was able
to fix the problem by recreating the tables (a real pain) and setting a new
ID number. I tried that yesterday with these tables and the only thing it did
was switch the project that it wasn't showing (it went from 1440000 to
1204600).

HELP!!! I'm stumped.
 
all data from the table not a query thru an SQL statement
Why are you not using a query?
Is this because you are only applying criteria to one of the categories and
not the others?
 
Back
Top