Count function

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
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
 
Thanks Duane.

I see how it works now.

Will not work for this application but did get the correct numbers.
 
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.
 
Back
Top