Docmd.runsql problem

[polina]

I run this code to find out how many records there are in the table

docmd.runsql ("select count (*) as intX from table1")
but vba gives an error.

How else would I get the number of the records in the table from the code?

 

[ghudson]

Check the help files for the DCount function for it has lots of options.

= DCount("*", "TableName")

HTH