Creating a report that prompts for a date range

[sbg2]

If I were to create another report where I didn't want to initially set the field to "Rush" or "Creative" in a Find Request because there are other values being counted that may not have either of those checked, but still needed to count the values at the end...how would I do it?

Are you looking for the number of times Rush or Creative are selected within this new found set?

Since a multi-checkbox field only stores the 1st value selected, is there a way to make it count values when both boxes are checked?

I can count just "Rush" and I can count just "Creative", but if both are checked it won't count using an "and" operator because there is only the 1 value being stored.

If(RushCreative = "Rush" &

[sbg2]

If I were to create another report where I didn't want to initially set the field to "Rush" or "Creative" in a Find Request because there are other values being counted that may not have either of those checked, but still needed to count the values at the end...how would I do it?

Are you looking for the number of times Rush or Creative are selected within this new found set?

Since a multi-checkbox field only stores the 1st value selected, is there a way to make it count values when both boxes are checked?

I can count just "Rush" and I can count just "Creative", but if both are checked it won't count using an "and" operator because there is only the 1 value being stored.

If(RushCreative = "Rush" &

[Ron69]

If I were to create another report where I didn't want to initially set the field to "Rush" or "Creative" in a Find Request because there are other values being counted that may not have either of those checked, but still needed to count the values at the end...how would I do it?

Are you looking for the number of times Rush or Creative are selected within this new found set? [color:"red"] Yes - It would be a count of Rush and a count of Creative and then a count of both that are checked

Since a multi-checkbox field only stores the 1st value selected, is there a way to make it count values when both boxes are checked?

I can count just "Rush" and I can count just "Creative", but if both are checked it won't count using an "and" operator because there is only the 1 value being stored.

If(RushCreative = "Rush" &

[Ron69]

If I were to create another report where I didn't want to initially set the field to "Rush" or "Creative" in a Find Request because there are other values being counted that may not have either of those checked, but still needed to count the values at the end...how would I do it?

Are you looking for the number of times Rush or Creative are selected within this new found set? [color:"red"] Yes - It would be a count of Rush and a count of Creative and then a count of both that are checked

Since a multi-checkbox field only stores the 1st value selected, is there a way to make it count values when both boxes are checked?

I can count just "Rush" and I can count just "Creative", but if both are checked it won't count using an "and" operator because there is only the 1 value being stored.

If(RushCreative = "Rush" &

[sbg2]

Are you looking for the number of times Rush or Creative are selected within this new found set? [color:"red"] Yes - It would be a count of Rush and a count of Creative and then a count of both that are checked

To find the count of field set to Rush or to Creative

* Define a new calculation field calc_Rush_or_Creative - If(Rush Creative = "Rush" or Rush Creative = "Creative"; "Y")

* define a global Text field g_Rush_or_Creative

* perform a find for calc_Rush_or_Creative = "Y"

* Set Field [YourTableName::g_Rush_or_Creative; Get(FoundCount)

If(RushCreative = "Rush" &