count total cages number in the "cage" column

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

Guest

Hi, we have this Access database which keep records of all our lab mice. usually there are more than one mouse in a cage. So the cage number has to be showed up in the database more than once. That makes counting total cage number so difficult when you get tons mice in your animal room.

I guess there got to be a way to count the total number of cages. Could anyone help?

thanks

ming
 
Create a query that returns the unique cage numbers and save it. (You do
this by selecting the properties for the query and setting Unique Values to
Yes). Create a query that uses Count on that unique cage query.


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



hausee said:
Hi, we have this Access database which keep records of all our lab mice.
Click to expand...
usually there are more than one mouse in a cage. So the cage number has to
be showed up in the database more than once. That makes counting total cage
number so difficult when you get tons mice in your animal room.
 
You could run a distinct query:

SELECT DISTINCT Rats.Cage FROM Rats;

And then the recordcount would be the number of unique cages.

Unfortunately, a count won't work and I know of no similar "count unique" SQL command, but this simple exercise should do it handily.
 
Back
Top