I want to count the total number of records I have stored on the db by using a text box and using the count function but I have not had any luck. I have tried =Count(*) and =Count([IDNo(*)) What is the correct syntax for this? All I seem to get is #error returned in the report

Many thanks

Try =Count([IDNo]) in the Control Source of your Text Box. Make certain to place the Text Box in the Report Footer of your Report. Also, this will only count the number of records that are contained in the Report's Record Source so be sure that the Record Source is accurate.

Good Luck

Pat

Do it with a query:

Select Count(*)
From YourTable;