Jump to content

Doing a Sort in Print Script


This topic is 5761 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5761 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Who Viewed the Topic

    1 member has viewed this topic:
    Lola 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.