Counting Records

[Dave]

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

Regards Dav

 

[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

 

[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
(e-mail address removed)

Many thanks Dave