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

DCOUNT Function,

P: 1
Hey there,

Im trying to Calculate the Count of records on a Table with Parameters from another Query used to pass Values for the Same Report.


=DCount("[OTIFIC - Measures]![DNOTENO] ","OTIFIC - Measures"," [OTIFIC - Measures]![MCU] =[Query2]![FirstOfMCU] "
And
" [OTIFIC - Measures]![DATEGEN] Between # [From]# And #[To] #")

But, Im not able to pass the Parameters.
Aug 14 '07 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 635
Hey there,

Im trying to Calculate the Count of records on a Table with Parameters from another Query used to pass Values for the Same Report.


=DCount("[OTIFIC - Measures]![DNOTENO] ","OTIFIC - Measures"," [OTIFIC - Measures]![MCU] =[Query2]![FirstOfMCU] "
And
" [OTIFIC - Measures]![DATEGEN] Between # [From]# And #[To] #")

But, Im not able to pass the Parameters.
Hi

This is very confused, but for a start I suggest these modes and then post what happens!

=DCount("[DNOTENO] ","OTIFIC - Measures","[MCU] = " & [FirstOfMCU] & " AND [DATEGEN] Between #" & [From] & "# And #" & [To] & "#")

You don't say where this code is, but I assume that [FirstOfMCU] , [From] and [To] are fields in a forms recordsource ??

More info is required, as to where/how you are using this.

MTB
Aug 14 '07 #2

NeoPa
Expert Mod 15k+
P: 31,616
Mike,
This is off-topic I know, but have you received a PM (Private Message) from me at all. I sent it a number of weeks ago but I'm not sure you've found the link to read them yet.
Please PM a response if you're able, or alternatively respond in here and I'll arrange to help with that and getting better communication going in the future.

Best regards -NeoPa.
Aug 21 '07 #3

Post your reply

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