number of records

  • Thread starter Thread starter ms shakeel
  • Start date Start date
M

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
 
-----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:
Click to expand...

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")
 
Back
Top