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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Access problem 0
Random Function for Selecting Records 3
wish there was a CountDistinct() function 6
average 3
Sum & Group By 1
Random Number in Query 2
why does Random: Rnd() not work for random sort? 2
Access Dcount (multiple criteria) 3

Back
Top