Hi
=DCount("*","qr yBc003_2_Xstats ")
The above syntax which was working for old tables is not working for new tables or queries , I have updated the changes the new query is working fine with no change in the query name, but reports with dcount are not working, whereas the others are fine.
=DCount("*","qr yBc003_Xstats", "([deposd] Between [startmonth] AND [endmonth])...