DCOUNT Function,

[luma27]

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.

[MikeTheBike]

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

[NeoPa]

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.