How do I sum the number of occurences of drop down values?

[mqbui]

To clarify:

1) I have a database with multiple records.

2) There is a drop down box with one of the values being "x"

3) I want to query based on a period of time to find the number of "x" related records in the drop down field.

Question: How do I create a calculation to add up the number of "x" occurences and be able to pass that value for further use?

Any help is appreciated.

Thanks,

Marc

[bcooney]

A query in FM is a Find. You need two criteria in your find: datefield= date range and field = x. You will end up with a found count. Then use Get(FoundCount) in any calc.

OR, setup a multi-criteria relationship btw your tables where dateA >= date1 and dateB <= date1 and globalfield = field.

Provide more detail and so will I.

[mqbui]

To be more specific..

When I make a query I want to be able to extract and manipulate data on the records queried set by conditional requirements of Initials field of "gtc" and the date parameter.

I have something similar set up below, where I'm using "Get" to find the total number or records in my query that have the conditional requirements fulfilled. I'm receiving value "0" even when some of the records queried have the conditional requirements fulfilled, what am I doing wrong?

If ( Incident::Initials = "gtc" ; Get(FindCount) ; 0)

[mqbui]

To clarify, I am only need to query based on date parameters, and based off of that, I need FileMaker to identify only records queried with "gtc" value in the drop down box.