By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,445 Members | 3,172 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,445 IT Pros & Developers. It's quick & easy.

Dcount

P: 1
Hi

=DCount("*","qryBc003_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("*","qryBc003_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
Jan 8 '07 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,494
What is 'Old' & what is 'New'?
If you're using Access 2K3 then you could try replacing "*" with '&'
Jan 9 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.