Laura, try changing the order.date field's attributes so that there is a FNC=LAST in the attributes. There are many ways to accomplish this, but this is the easiest one to start off with. This may not work because the OE.ORDDPM is based on the order's URN, not a patient. Also, if you're not sure where the field attributes are, I'd be happy to give you more detailed instructions.
If it does not work please let me know, and I will work with you to find the solution. Robert Simplicio President Simplicio Systems, Inc. [EMAIL PROTECTED] http://simplicio.com <http://simplicio.com/meditech-l> On 5/23/07, Wasielewski, Laura < [EMAIL PROTECTED]> wrote:
I have a report written in OE.ORD Detail Segment oe.order. The report picks up Respiratory orders. If the patient has multiple orders of the same procedure I need it to show the last one entered. For example, if the patient has a procedure EAROX entered on 05/20/07 and 05/21/07 I only want to see the order for 05/21/07. Can anyone help me with this. Thank You Laura Wasielewski St Josephs Hospital Elmira, NY [EMAIL PROTECTED] Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= 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
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= 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