A
Annette
I have a table of clients and a table of services the client is
enrolled in. The relationship between client and services is one to
many -- a client can have many services.
The client's service table consists of the clienID, program enrolled,
enrollment start and end date.
Some clients will be enrolled in many programs.
I would like a query that specifically lists all the clients that were
enrolled in program 1030 that are now enrolled in program 1041. The
detail records for services for a client would show that they had a
start/end date for program 1030 and then a start and possibly an end
date for program 1041. It should follow protocol that program 1030
ended on one day and the start of 1041 started the next day.
How do I create this?
enrolled in. The relationship between client and services is one to
many -- a client can have many services.
The client's service table consists of the clienID, program enrolled,
enrollment start and end date.
Some clients will be enrolled in many programs.
I would like a query that specifically lists all the clients that were
enrolled in program 1030 that are now enrolled in program 1041. The
detail records for services for a client would show that they had a
start/end date for program 1030 and then a start and possibly an end
date for program 1041. It should follow protocol that program 1030
ended on one day and the start of 1041 started the next day.
How do I create this?