Count function

[Guest]

Trying to have a count performed based on field data as follows:

Record 1 ID=123 data = 2000
Record 2 ID=987 data = 1000
Record 3 ID=123 data = 3000

The result of the "Count" function needs to be "2" ie: Count of ID #'s not
how many records with ID's.

How is this done?

 

[Duane Hookom]

Did you read Marsh's response to the most recent thread prior to yours?

 

[Guest]

I see the response - have no idea what he is saying.

Tried to use the "FieldCount()" and then the Help menu searching for Field
Count. No help.

Still lost.

 

[Duane Hookom]

Can you sort your report by ID?

 

[Guest]

Yes - it is a Text field.

 

[Duane Hookom]

Sort your report by the ID field and create a group header or footer
section. Add a text box to the new group section:
Name: txtCountID
Control Source: =1
Running Sum: Over All
Visible: No
Add a control to your report footer section:
Control Source: =txtCountID

 

[Guest]

Yes, the filed is Text
--
A MACKENZIE, CMA, MBA

Can you sort your report by ID?

 

[Guest]

Thanks Duane.

I see how it works now.

Will not work for this application but did get the correct numbers.

 

[Duane Hookom]

Are you still looking for an answer? If so, just create a query or series of
queries that ends up with a single record with your value. Add this query to
your report's record source so you can display the value in your report.