counting random numbers in a field.

  • Thread starter Thread starter sue
  • Start date Start date
S

sue

i need help writine a querry that counts the number of times a number (1 -
300) appears in a certian field. The number is a random number with limits 1
through 300.
 
What have you already tried?

Take a look at the Totals query toolbar button in the query design view.
You could use the GroupBy aggregation and the Count.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top