I kind of do that in my HIPAA tracking database, the views are all set to get records by the current year, if they need to look earlier they need to specify that requirement and requery.
v/r //SIGNED// Stephen S. Wolfe, YA2, DAF 6th MDG Data Services Manager 6th MDG Information System Security Officer Comm (813) 827-9994 DSN 651-9994 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Stanton Sent: Wednesday, August 08, 2007 7:31 AM To: [email protected] Subject: Re: Data Strategy > To be more specific about an example, someone on the database may have > been making payments for several years, but the finance person only > needs to see this year. To be more accurate, the finance person usually *wants* to only look at "this" year, though needs the ability to vary this, of course. Mark Stanton One small step for mankind... [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
