AnsweredAssumed Answered

Table needed for displaying field information

Question asked by stanschoonover on Jan 5, 2017
Latest reply on Jan 11, 2017 by user19752

I have a FM Pro database, and want to display information in a table-like way.

Field name is "Block"

Contains letters A-G.

Field Name is "Instrument"

Contains about 15 wind instrument names- ie "Flute", Bassoon, etc.

800+ records

 

Trying to create a layout that will display how many of each instrument are in each block.

I'm guessing this is some kind of summary......................

How many flutes have "A" for their block, how many have "B", etc.

Then the next instrument "A" block, "B" block, etc.

 

Instrument Field would go down the page

Block A  Block B  Block C, etc. across the page

 

 

Thanks.

Stan

Outcomes