There is no such thing as a stupid question, but you can get a plethora of stupid
answers. This might be one of them <G>
Create a table with quarters, first and last dates, and populate it
CREATE TABLE Quarters (Quarter INT NOT NULL PRIM KEY, +
QStart DATE NOT NULL UNIQUE,+
Qend DATE NOT NULL UNIQUE)
20031, 01/01/2003,03/31/2003
20032, 04/01/2003,06/30/2003
etc.
This table assumes that you need to identify 4th Qtr 2003 requiring entries in 1st
Qtr 2004. Now you can look things up by linking dates by the quarter limits in the
Quarters table.
You could get fancy and create a view that gives you the quarters, but why bother.
"Plateautel.net" <[EMAIL PROTECTED]> wrote:
>Can anyone help? �Stupid question, huh? �Please help!
>
>Working in a mental health facility, the clinicians are required to perform quarterly
>reviews on clients.
>I have a table that contains
>
>Client_ID � � Integer
>Unit � � � � � � Integer
>Svc_Code � �text
>Svc_date � �date
>Server_ID � �Integer
>
>A Svc_code of 122 is a quartely update
>A svc_code of 150 is an ASI
>
>I need to find out two things
>
>If the client had any services, regardless of the unit, in the 2nd qtr, �then a
>svc_code of 122 must be performed in the third qtr.
>I need the client_id and Server_id for any clients that have any services in the
>second qtr, but do not have a Svc_code of 122 in the third qtr.
>
>Also,
>If the client is assigned to unit 102 and has had any services in the 2nd qtr then a
>svc_code of 150 must be performed in the third qtr.
>I need the client_id and Server_id for any clients that are assigned to unit 102 and
>has services in the second qtr, but does not have a Svc_code of 150 in the third qtr.
>
>Please
>
>
>
--
Albert Berry
Full Time Consultant to
PSD Solutions
350 West Hubbard, Suite 210
Chicago, IL 60610
312-828-9253 Ext. 32
__________________________________________________________________
McAfee VirusScan Online from the Netscape Network.
Comprehensive protection for your entire computer. Get your free trial today!
http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397
Get AOL Instant Messenger 5.1 free of charge. Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
