Been trying to work this out, hope it's a simple answer for someone here! I have a databse that logs field activity by date, time, task etc. Field workers report in at various times and they log in their own tasks performed during the day. At the end of the night, the supervisor needs to print a daily log for the bosses to read in the AM. So I need to find it by date, then sort it by time and print. I got the date find easily, but how do I get the found records to sort in chronological order prior to printing? Thanks for any help.

If you do this manually, Find on your date field

and then sort based on the date and the tine.

You will need to Sort the fields anyway in order for the Sort in the Script will work too, It defaults to the last performed Sort.

Create this Script:

Go to Layout [original layout]

Enter Find Mode []

Insert Calculated Result [select, “YourDateField”, “"Status(CurrentDate)”]

Perform Find [Restore]

Sort

HTH

lee