number of records

[ms shakeel]

hello sir,

thank u for help in advance
i want to know as to how i can get the number of records
obtained in the result of a select query ,the select
query,being applied on a table,that is i want to get
the "NUMBER OF RECORDS" obtained from result of select
query,that number i want to get.

thank u
shakeel

 

[tina]

-----Original Message-----
hello sir,

thank u for help in advance
i want to know as to how i can get the number of records
obtained in the result of a select query ,the select
query,being applied on a table,that is i want to get
the "NUMBER OF RECORDS" obtained from result of select
query,that number i want to get.

thank u
shakeel

.
a couple of simple ways:

create a new query, based on your existing query. pull a
field into the QBE grid, and enclose the field name as
Count(FieldName)
go to datasheet view, and you should see one record with
one field that gives you the number of records in the
underlying query.
OR
use a domain aggregate function (in your form or report,
for example), as
DCount("[FieldName]","QueryName")