Gilliam,
try using the command " apply to selection"
ALL RECORDS([ProgNotes])
QUERY([ProgNotes];[ProgNotes]DOS>Current date-90)
ORDER BY([ProgNotes];[Patients]NameLast;[Patients]NameFirst;
[ProgNotes]DOS;<)
APPLY TO SELECTION([ProgNotes];LastVisit:=True)
HTH
Martin
**********************************************************************
4D Basics hosted by 4D, Inc.
http://www.4D.com/An all-new List box. More features, more power.
Headers, footers, cell formatting and other goodies.
See it here first! <
http://www.4d.com/livedemos>
To Unsubscribe: mailto:
4DBasics-off@...
**********************************************************************
