Brandon - try this report. I recently had a similar request and this was the response. The macro contains the randomization logic:
Douglas B. McGaw Newman Regional Health 1201 W. 12th Ave. Emporia, KS 66801 [EMAIL PROTECTED] 620-343-6800 x 1130 fax: 620-340-6799 ________________________________ From: meditech-l@MTUsers.com [mailto:[EMAIL PROTECTED] On Behalf Of Gauntt, Brandon K. Sent: Friday, April 06, 2007 7:56 AM To: meditech-l@MTUsers.com; [EMAIL PROTECTED] Subject: [MEDITECH-L] random SSN report for random drug screen I have a request to create a report that will randomly select x number of employee social security numbers for random drug screening. I actually do not have the slightest idea as to how to write anything in NPR that would randomly pick a field every time it is ran. Does anyone out there have any type of report that would do something like this they would be willing to share? I would appreciate any help with this. Brandon Gauntt Director - Information Services Hopkins County Memorial Hospital 903-439-4054 Office 903-348-2112 Cell This e-mail, facsimile, or letter and any files or attachments transmitted with it contains information that is confidential and privileged. This information is intended only for the use of the individual(s) and entity(ies) to whom it is addressed. If you are the intended recipient, further disclosures are prohibited without proper authorization. If you are not the intended recipient, any disclosure, copying, printing, or use of this information is strictly prohibited and possibly a violation of federal or state law and regulations. If you have received this information in error, please notify Baylor Health Care System immediately at 1-866-402-1661 or via e-mail at [EMAIL PROTECTED] Baylor Health Care System, its subsidiaries, and affiliates hereby claim all applicable privileges related to this information.
pprandom.npr
Description: pprandom.npr
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= To subscribe or unsubscribe to the meditech-l, visit MTUsers.NET. To check the status of the meditech-l, visit MTUsers.NET. For help, email [EMAIL PROTECTED] Visit the MTUsers WikiPedia at MTUsers.NET/mwiki ______________________________________ meditech-l mailing list meditech-l@MTUsers.com http://mtusers.com/mailman/listinfo/meditech-l