# of people served qry

[nydia]

i am trying to pull information form this database (i
didn't create). i need to find out how many people were
served from Jan. 1, 2003 thru Dec. 31, 2003. This
database doesn't have an entry date all is has is a
termination date field.

what criteria would i put in the termination date field
that will bring up all clients that where open at any
given time between these dates.

in another dba that i have it has an entry and termiantion
date so my criteria for this would be

entrydate terminationdate
<12/31/03 >1/01/03 or is null

 

[Michel Walsh]

Hi,



.... WHERE terminationDate < 1+ #12-31-2003#
AND terminationDate >= #1-1-2003#



Note the 1+ adds 24 hours, (ie, up to #12-31-2003 23:59:59# plus one
second), otherwise, you end up one day short (anything occurring the
12-31-2003 else than at 00:00:00 precisely, would not have been considered).


Hoping it may help,
Vanderghast, Access MVP

 

[John Spencer (MVP)]

HARD to say.

Where TerminationDate Is Null or
TerminationDate > #/1/1/03#

should work as well as anything can to limit this to people that were never
terminated or were terminated after the beginning of 2003. The problem is you
have no way of knowing when they entered the program unless you have another
table that gives you dates that services were performed for the individuals.
Then you could use that to identify the people served.