2 Replies Latest reply on Aug 7, 2015 10:58 AM by FernandoFlores

# Calculating the number of times a particular vaccine has been given within a particular age range.

### Title

Calculating the number of times a particular vaccine has been given within a particular age range.

### Post

Hi everyone,

I'm fairly new to FileMaker so please bare with me and thank you in advance! The task I'm currently trying to achieve has got me completely stumped. I've tried a number of approaches, including summary fields, sub-summary parts, and scripts.

The table is used to keep track of immunization records for people. The important fields in this table are, "ImmunizationName", "Round", "Age", "AgeGroup", and "RoundTotal".

What I'm trying to achieve is to have a field that can calculate the number of times a particular immunization has been given within a particular age group.

I've attached a screenshot of a table that better demonstrates what I'm trying to achieve.
For example,
It would show the Hepatitis B, round 1 vaccine has been given 3 times to the age group "5-9" (or whatever age range it is meant for)

I'd really appreciate some help. Thanks everyone!

• ###### 1. Re: Calculating the number of times a particular vaccine has been given within a particular age range.

It would show the Hepatitis B, round 1 vaccine has been given 3 times to the age group "5-9" (or whatever age range it is meant for)

Are you sure that you uploaded the correct image? I don't see that in your screen shot. There's no 5-9 group. There's a 6-9 group, but I don't see any data recorded in it. The column headings are the age group? And I can tell that the first two rows refer to "measles, mumps and rubella", but can't tell what row would refer to Hepatitis B, round 1...

Is the chart shown a representation of how your data is stored in your database, how the data should be reported or just a sample of the current "paper" based system of recording or reporting this data?

• ###### 2. Re: Calculating the number of times a particular vaccine has been given within a particular age range.

I'm sorry for the confusion. The image was correct but my worded example was not. I've attached a better representation.

The chart is a representation of the current "paper" based system of recording the data.

I need to represent this in a layout.