Counting all the records in the table w/ other fields

[lfast]

When you have multiple fields that are displaying,

how do you display the count of the total # of records that

are pulled from the query.

I.E. , at the bottom of the screen (when you have it enabled) you'll see the total number of records.. But you would like to append this to the query so that it would display as an additional field..

Thank you!

David Brook

 

[WildHare]

Check out the RecordCount property of a dataset. It should give you what you want.

There are two ways to argue with a woman - neither one works.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[lfast]

Pl. excuse my ignorance, but how do you check the RecordCount property of a dataset.

Thanks for your other responses !

David

 

[cmmrfrds]

You can get the record count from your Forms query by.
Me.recCount