shamrog12

My situation explained: I have 15 fields I need to use information from (3 rows of 5): Product01, Product02, Product03, Product04, Product05 Quantity01, Quantity02 ... Quantity05 ID01, ID02, ... ID05 My fields are set up like this: | Product01 | Quantity01 | ID 01 | | Product02 | Quantity02 | ID 02 | | Product03 | Quantity03 | ID 03 | | Product04 | Quantity04 | ID 04 | | Product05 | Quantity05 | ID 05 | A possible scenerio would look like this: | Baseball Glove | 20 | BG001 | | Football | 5 | FB001 | Volleyball Net | 20 | VB001 With hundreds of records with these fields and information on them, I need to find out how I can display the total quantity of BG001 sold throughout all the records and the total quantity of FB001 sold throughout all the records and same for VB001. I have NO CLUE how to do this and I've been trying to figure it out for days now with absolutely ZERO luck. Please help!

My situation explained: I have 15 fields I need to use information from (3 rows of 5): Product01, Product02, Product03, Product04, Product05 Quantity01, Quantity02 ... Quantity05 ID01, ID02, ... ID05 My fields are set up like this: | Product01 | Quantity01 | ID 01 | | Product02 | Quantity02 | ID 02 | | Product03 | Quantity03 | ID 03 | | Product04 | Quantity04 | ID 04 | | Product05 | Quantity05 | ID 05 | A possible scenerio would look like this: | Baseball Glove | 20 | BG001 | | Football | 5 | FB001 | Volleyball Net | 20 | VB001 With hundreds of records with these fields and information on them, I need to find out how I can display the total quantity of BG001 sold throughout all the records and the total quantity of FB001 sold throughout all the records and same for VB001. I have NO CLUE how to do this and I've been trying to figure it out for days now with absolutely ZERO luck. Please help!

Ok, I think I'm getting what you mean. Just to provide more information I'll set up the scenerio. I have ID01, ID02, ID03, and next to them are QUANITITY01, QUANITITY02, QUANITITY03 respectively. In each of those ID fields I can name any one of mour product IDs and quantity is a variable of course. I need to somehow get a list of all of the different IDs in all the records and next to that have the quantities of each. This information spans over hundreds of records. I'll investigate what you said to try. Thanks! and I welcome any other ideas or help also.

PLEASE PLEASE help. New to FMPro and I have a DB with a field called ID01 which is the product ID. Next to it is a field called QUANTITY01, for quantity. I have hundreds of different records all with those two fields in particular. I have to find out the total quantity of each possible product ID for all records. Advice? Help? Thanks in advance.

I have a repeating field named "ProductName" and it repeats 2 times. As you can guess it is for products and what I am in need of is to track how many of each product we sell. If I have (for example) "bat" and "glove" as the two products in my repeating (2 times) field and each has a quantity of "1" as defined in a field called "Quantity", I find that I can't write a calculation that that detects that "bat" exists and has a quantity of "1" and that "glove" exists and has a quantity of "1." My calculations seem to only see the product name or quantity at the top. This makes it very hard for me to somehow keep record of the total quantity sold of each product for all records. Any ideas? I'm new at this and need some guidance and advice. Thanks in advance.