I want to do a report on people who entered my facility within a date range, for example from 1/1/2012...12/31/2012 (or any range of dates) and subtotaled by month.
Everyone has an Entry Date and an Exit Date.
Month # Entered
Jan 2012 23
Feb 2012 21
Mar 2012 32
I can do this report with a script that does a find with a global start and end dates such as:
Enter Find Mode
Set Field [EntryDate;g_date_start & “...” & g_date_end]
Then can do a subsummary by Month (Year (EntryDate) & Right("0" & Month(EntryDate);2)
and it all works fine.
What I want to be able to do is to get the number of people who exited the faciltiy on this same report for the same date range. For Ex:
Month # Entered #Exited
Jan 2012 23 16
Feb 2012 21 22
Mar 2012 32 24
I can't seem to figure this out. Is it possible?