have a government form that asks for totals by page the fields I'm totaling are in a portal and the first page only shows 5 records and the following pages show 19 records each. Is there a way to total the records that are on each page? Thanks JT
What you should investigate are subsummary parts and summary fields. This will allow you to create a print layout based on the table occurrence attached to the portal that will organize your related records into groups without a portal.
Considering this. We receive parts from a manufacture or send them out to another member of the team, the document gets a number (tracking). The portal is to the parts that are moving are placed in a table tied to the tracking number, the parts are in random order none related to any group other than the tracking number. So how could I group these since this is a Government form not much of a chance to change the form. so that is the reason for the different number of records on the first page and the following pages. Does this make since?
If they are grouped in a portal then they can be grouped by a subsummary part. Just use the foreign key field if needed.
You are over my level of knowledge. Say I have 30 parts (records) that belong to an order. First page 5 records, second page 14 more records and the next page has 11. How do I do this for subtotals for each page. See attached.
Without seeing your database, it's going to be hard to give you specifics. Have you looked at how subsummary parts work yet?
Have glanced over that section this morning but will look over it in depth this evening. Thanks JT
Retrieving data ...