Row Count

[jakehale]

Can i build an expression in a queary that give me a row count? i have a column named NAME, instead of looking at the bottom to see how many records i have i would like to have a column that has a count of the number of names i have, not like names, or different names,, just a count of the names.
once i print out my report i would like to see the total number of names instead of having to count them all..

thanks

 

[jakehale]

ok

so on the report,, in the footer just put in =count(*)? what is it counting? do i need to place a "field" in there someplace?

I know name is generic,, but it is "names"

thanks for the the help

 

[tiggy]

Hi,

Will anything on this example help

Tig

 

[jakehale]

thanks

well it is counting but thats not really what i am looking for.

all i really need is a "block" at the bottom of some of my reports that has a number and that number is the total number of names i have....

i wish i had better understanding of how this program works, i know you can do so much with it...

thanks for the help thus far

 

[doulostheou]

In = Count(*) you could replace the asterisk with a field name if you choose, but the asterisk represents all the fields in your row of data. So you are basically saying count the rows. If you count your name field, you should find the same result.

Avoiding the use of the word name is not good because it is generic but because it is a keyword used by access. This will not create a big problem unless you begin to implement VBA, in which case it will confuse the field name with the Access keyword "Name". There are ways to distinguish between the two, but it is good to make it a general practice to avoid using keywords like Name or Date, which while they may do a fine job of describing a simple table can cause complications later.