Hello Everyone,
I am trying to create a report that will calculate the number of children served within a period of two dates (a quarter). The issue I am having is that within the Children table, there is no date field, so I am not sure how to determine which children were "Active" during this period.
I have tried taking information from three different tables. All three tables are connected through the FuID (Family Unit ID).
The first is the Family Unit table which consists of FuID , FamName , Active (Yes/No).
The second is the Case Status table which consists of CsID, FuID, Status (Waitlist, Active, Closed, etc.), and StatusEffective (date).
The third is the Children table which consists of ChID , FuID, LastName, FirstName, DOB, and Active (Yes/No).
The first two tables are not really necessary for the report, but I tried using the StatusEffectiveDate from the Case Status to get the Between dates, but this only pulls children that have had their Case Status updated within that time frame.
Ultimately, I would like the query to pull .... What children were checked off as Active between Date 1 and Date 2, regardless if they became inactive between these dates. Is this possible without a date stamp in the table?
For my first database, everything had seemed to be set up correctly (thanks to you guys) until this problem!
Thanks in advance!