Total of all records

[cos01]

Hi all

I have created a report which filters certain 'completed' records and diplays the total number using the COUNT(*) funtion. I would also like the report to display the total number of records within the source table(?), so that I can create a percentage of records completed(this last bit I am okay with). What command do I use to create this number of all records?????????

Thanks in advance

Craig

 

[Engelking]

Try looking at the dcount function in help, It will count all the records from any table or query.