I have multiple items in the one field these are entered automatically by using a formulae that whereby each item has a ID number that I enter in another field then the item is entered in to the field automatically

I have attached a pdf file, the field listing the type is is the field that i need the totals for, although this field lists the items each item has it own ID that are listed in a separate folder, I will need to list the type, size and totals

If you are using Windows, you can use the ctrl-shift-print Screen to capture a screen shot in your clipboard. You can then open the Paint accessory, paste and edit your screen shot. THen you can save the image as a jpg, png or gif file.

Similar steps are possible for Mac, but I haven't done that in years so don't remember the exact sequence of steps to use--nor if they have changed.

Files of other types--such as a PDF--may be uploaded to a file sharing site and then the down load link can be posted in your next response to this thread.

Hi, I have set up the following Table & Fields, I have attached a copy of layout, this may help

Table,

Product Type

Fields,

Product Type ID

Product Abbreviation

Size

Types

Co2

Dry Powder

Foam

Hydro Spray

Water

Wet Chemical

When entering a product to a site I enter the required ID code this enters the correct type to the site and whether the type is measured in kilogram, letter or centre meters then I will enter the capacity/size, as I enter these to a site I want to caculate each type and size for each site so that I can enter a field on a report to display the quantities.

Unfortunately, we are still dealing with the same question about records vs. fields. What you show could be a repeating field with 9 repetitions or it could be 9 separate records.(Either would look the same as what you have in the above image.)

What you request will be much easier to set up if you have 9 records instead of 9 repetitions.

Assuming 9 records here instead of repeating fields...

A summary report (which would require a different layout design than what you show) could easily use a summary field and sorting to group the records by size and type to compute a subtotal for each along with a grand total for the whole group of records.

The layout you show is also possible, but requires creating a summary table with which to compute and display the sub totals for each pairing of size and type.

InspectionItems and InspectionItems 2 are two occurrences of the same table.

Your layout would be based on Sites--which has field defined for SiteID, Address fields, ect. Witha portal to InspectionItems to provide the upper list of items inspected with a portal to SizeTypeSummaries to list the totals shown at the bottom of this layout.

You'll need to create one record in SizeTypeSummaries for each unique combination of size, type and site. A script trigger on the size and type fields can perform a simple script to create the matching record in SizeTypeSummaries.

Define a Summary Field in InspectionItems as the "count of" _fk_SiteID or any other field that is never blank to produce your total count of items inspected of that size and type.

In your portal to SizeTypeSummaries, place this summary field, but selected from Inspection Items 2 in the portal row to show the totals. Place this same field outside of the portal to show a grand total count of all items inspected. (Note: Calculation fields that use Count can be defined in SizeTypeSummaries instead of using the summary field in InspectionItems. That option can be the better choice if you are using the upper portal for data entry as the totals will update more smoothly.)