AnsweredAssumed Answered

count ID of repeating field???

Question asked by sapphire_1 on Feb 19, 2009
Latest reply on Feb 22, 2009 by sapphire_1

Title

count ID of repeating field???

Post

Hello,

I am very new to file maker and currently using file maker pro 9 advanced.

I have a repeating field called 'Types of food' which has 3 repetition.

I need to summarize the types of food for example:

Types of food   Product1     Product2     Product3

Record 1          milk              egg           bread

Record 2          cocoa         coffee          egg

Record 3          cocoa           milk            milk

into something like this:

milk         3

egg         2

bread      1

cocoa      2

coffee     1

I've tried using subsummary but what I get is:

milk            1

egg

bread

cocoa        1

coffee

egg

cocoa        1

milk

milk

I also tried using GetRepetition() function, but what I get is summary for repetition1 in a report, summary for repetition 2 in another report and summary for repetition 3 in another report.

Can anybody help me?

Thank u.

 

 

Outcomes