Information showing that I don't want!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report to track the number of months clients are "active" before
receiving services. I also have three seperate fields for different dates
because clients can be opened and closed up to three times in the database.
The problem is that in the report, clients who have been opened more than
once have each date show up with the total months they have been "active."
What I would like to do is have the report show only the date that they are
truly opened. I don't want the other dates to show because they are
irrelevant due to the fact that the client was already closed that first time
around.
 
It sounds like your data structure that is the problem here.

From your description, you can have different "cases" that are active for a
client over time. It is not the client who is active/inactive, but the case.
You will therefore need a related table of cases for each client, and move
the Inactive field into the Case table instead of the Client table. You will
then be able to create a query based on both tables, and show only the
active cases in your report.

Post back if I have not understood you correctly.
 
Back
Top