Count Query

[karmaimages]

Hi,

I have a table called DWP_Data_Backend - New form called "Stats" -



In the table i have various fields - one called Surname - I want to just display a field in say a text box that counts the total number of records in table DWP_Data_Backend that have data entered. Is there an easy way to do this, I can't seem to work out how to create a query to do this?

[orange]

For a query the sql would be

Select  count(*) from DWP_Data_Backend

If you are working with a form, you may want to investigate Dcount

Good luck.

[karmaimages]

For a query the sql would be

Select  count(*) from DWP_Data_Backend

If you are working with a form, you may want to investigate Dcount

Good luck.

Hi,

If i enter

Select  count([Surname]) from DWP_Data_Backe

in the expression builder it comes up with an error: The Syntax of the Subquery in This Expression is Incorrect

[orange]

What subquery? You'll have to show us more info. Attach you database in zip format so readers can see what you are dealing with.

You don't have a table called

DWP_Data_Backe

Cross Posted??
http://www.utteraccess.com/forum/ind...ic=2034579&hl=