Dcount (1 Viewer)

[mester]

Hi everyone, if you please i wanna count how many lignes between two dates, i mean date from A to B. So i used dcount, but i didn't know what to use in the criteria.
Me.textbox1=Dcount("[expr1]","table1","[criteria1]= between #"& me!textbox5 &"# and #"& me!textbox6 &"# ")
Is this one correct please????

 

[Isaac]

Me.textbox1=Dcount("*","table1","between #" & format(me.textbox5,"mm/dd/yyyy") & "# and #" & format(me.textbox6,"mm/dd/yyyy") & "# ")

Does that work?

 

[mester]

Me.textbox1=Dcount("*","table1","between #" & format(me.textbox5,"mm/dd/yyyy") & "# and #" & format(me.textbox6,"mm/dd/yyyy") & "# ")

Does that work?

Hi , i am working on it to see if it will work

 

[mester]

Me.textbox1=Dcount("*","table1","between #" & format(me.textbox5,"mm/dd/yyyy") & "# and #" & format(me.textbox6,"mm/dd/yyyy") & "# ")

Does that work?

Sorry Sir, it doesn't work for me.

 

[Isaac]

Can you post (Copy and Paste into your response here) the expression you're using in the Textbox?
Or the code, if it's VBA ?

 

[Isaac]

Sorry, typo:
Try:

Me.textbox1=Dcount("*","table1","[DateFieldName] between #" & format(me.textbox5,"mm/dd/yyyy") & "# and #" & format(me.textbox6,"mm/dd/yyyy") & "# ")

 

[mester]

Here is the code i used, thanks for your help

 

[Isaac]

I corrected typo, see prev. post, thx

 

[mester]

I corrected typo, see prev. post, thx

Thanks Sir, it works now, thanks a lot

 

[Isaac]

Thanks Sir, it works now, thanks a lot

Awesome, glad I could help.