Access MS Access DCount function problem

Jul 22, 2015
Reaction score

I am new to the forum and am hoping someone can help me with a DCount function problem I am having in MS Access.
I have report that is run from a query that selects records between 2 dates. The query runs fine, in the report I have a control box (TotalTrade) in the footer section with the following expression:

TotalTrade = DCount("[Tradecnt]","qryTradeJournalDateCloseDate")

This gives me an #error message, if I change the domain part to a table that the query is sourced from call tblTradeJournalData the DCount function works fine, for the life of me I cannot work out why the error when referencing my query, the spelling is correct for the query name.

I know I could just use the Count function, but from this I was going to use the criteria part of the function to count certain records based upon another field called WinLoss which is a text field, I thought I would start simple and then move into the more complicated aspect


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount function in access 0
Access Dcount (multiple criteria) 3
Dcount returning no results!!! 0
Access #Error & Excel Pivot 0
DCount alwaysreturning 1 0
Dcount the values 0
DCount Not Working Properly 7
Still struggling with DCount 8