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]) AND ([apptyp]='REPBN')")
Even this is not working, Can somebody please help me out with, I tried all possible ways.
Thank you
=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]) AND ([apptyp]='REPBN')")
Even this is not working, Can somebody please help me out with, I tried all possible ways.
Thank you
Comment