Thanks David! That is what I ended up doing.
James Belisle ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Fitts, David A. Sent: Monday, March 28, 2011 7:18 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: last entry based on criteria Hi James, I have noticed that the where clause COUNT = LAST can be used with other criteria. Perhaps a line in an EEP like: SELECT data FROM table WHERE COUNT = LAST AND EMPLOYEENAME = 'whatever name' would work.? Regards, David Fitts State of Maine Risk Management Division 287-3352 1-800-525-1252 ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Monday, March 28, 2011 7:04 AM To: RBASE-L Mailing List Subject: [RBASE-L] - last entry based on criteria While entering information in a form, I want to bring up in a field the last entry based on an employee name and one other criteria. This would not be the last row entered in the table, but the last entry for that employee. What code would I need? I This would be in an On after start EEP, I assume. James Belisle
