I am working on an access database and I want to get a value by a query in witch I used Dcount statement but it shows run-time error 3075. The following is my query, can anybody help and tells me what's wrong with my query?
strTotalNumber = "Select estaQeza, DCount('[" & Subject & "]', 'UnionQueryPersanalInfo', '[" & Subject & "] <> ''') As TotalCount From tblMain Group By estaQeza"
~~~~
[enter image description here][1]
[1]: https://i.stack.imgur.com/TRSwZ.png