CODEWITHSUNDEEP
sqlms-accessvbams-access-2010
Tai Lung
Tai Lung

Reputation: 89

Count Query records to a text box in MS Access

I would like to count the number of records in a query(named DUNKEL) to a text box. Here is what I did. In the Expression builder of the text box I have the following code :

=Format(Dcount("*","DUNKEL"),"000")

It gives me a syntax error. Where am I going wrong with it?

Upvotes: 0

Views: 480

Answers (1)

Sergey S.
Sergey S.

Reputation: 6336

Function arguments separator depends on operating system regional locale and may be coma or semicolon. If your current locale has separator “;”, just replace comas to semicolons.

Upvotes: 1

Related Questions