I need help with a query statement. I'm wanting to list the last event for each field that has had an event after 6/1/09.
vQuery = "FOR EACH field NO-LOCK, LAST event NO-LOCK WHERE event.num-field = field.num-field AND event.dt-end >= 6/1/2009 BY event.dt-end".
This query is listing all of the events after 6/1/09, not just the last event record.
You should probably move this question to the ABL forum for best attention. This forum is for sharing code you have written with others.