summing others

[Ocean West]

dreamweaver wrote:

quote:

---

i am trying to show only the first 20 records of a search and sum all the other records found as a 21st recors called others, any help guys?

---

[john.daly]

If I understand it correctly what you are wanting to do is change from a Form View to a List or Table View once you reach the 20th record. You need therfore to hide the status bar and make your own buttons to show the next and previous records. The NEXT button would run a script that would simply go to the next record until it reached the 20th record. After the 20th record the script would go to a second layout, omit the first 20 records and then show the remaining records in List View. Of course the Previous button on this second layout would need to find the first twenty records that had been omitted, (you may have to mark the original found set) and then return to the original layout and go to record number twenty.

Hope this helps.