Counting Records

D

Dave

Is it possible in Access to get a Sum of the records entered by runnin
a query.

Regards Dav
 
T

Trond Hoiberg

Err ... yes. Your question is hard to understand but you can do a rowcount
in a query. This can be done like this:
SELECT Count(RecordID) AS CountRecords FROM T_YourTable;

If you on the other hand want the sum of lets say 10 records with a column
where you have entered a sum like 34 (that can be money or how many people
attend a lesson) and you want the total from all 10 records you use SUM:
SELECT SUM(People) AS SumRecords FROM T_YourTable;

Best regards
Trond
 
D

Dave

Thanks for he reply...is there anyway known you could possible pu
something small together and show me what you mean...Im only a basi
user, my email address is
[email protected]

Many thanks Dave
 
Top