N
nydia
i have a dba that keeps track of client information for a
specific program. i have several tbl's but the 2 main
tbls that i need to work with are tblclientinfo, this
tables fields are clientname, address, d.o.b.
tblclientdates fields are startdate,terminationdate and
terminationstatus(terminationstatys=negative placement,
G.E.D.) I need to create a qry that will show me within a
given year, a count of how many clients came through the
program, how many clients terminated the program. these 2
tables are related by clientID
example
between 01/01/03 and 12/31/03 31 clients entered the
program
between 01/01/03 and 12/31/03 15 clients terminated the
program
how can i do this
specific program. i have several tbl's but the 2 main
tbls that i need to work with are tblclientinfo, this
tables fields are clientname, address, d.o.b.
tblclientdates fields are startdate,terminationdate and
terminationstatus(terminationstatys=negative placement,
G.E.D.) I need to create a qry that will show me within a
given year, a count of how many clients came through the
program, how many clients terminated the program. these 2
tables are related by clientID
example
between 01/01/03 and 12/31/03 31 clients entered the
program
between 01/01/03 and 12/31/03 15 clients terminated the
program
how can i do this