Using Dcount with combo box and date range (1 Viewer)

[RyLane]

Hi,

I would like to have a text box display the number of records for a selected title that fall within a selected date range. Been looking around for a while and have this so far;

=DCount("Discussion_Title","Discussions","[Discussion_Title]='" & [cboType] & "' And [Discussion_Date] = Between ([txtStartDate] And [txtEndDate])'")

I get an #Error message. Any ideas? I just threw that together because it describes what I want, but I know there are syntax problems.

Thanks

 

[KenHigg]

Something like -

=DCount("Discussion_Title","Discussions","[Discussion_Title]='" & [cboType] & "' And [Discussion_Date] = Between #'" & ([txtStartDate] & "'# And #'" & [txtEndDate]) &'#")

???

 

[pbaldy]

Or perhaps:

=DCount("Discussion_Title","Discussions","[Discussion_Title]='" & [cboType] & "' And [Discussion_Date] Between #" & [txtStartDate] & "# And #" & [txtEndDate] & "#")

 

[RyLane]

That does it perfectly! Thanks

 

[pbaldy]

Happy to help!