DCount between dates - Please Help :)

[basacwards]

Hello all,

I could really use some help with my form. I have a form with a text box "txtSdate" and a text box "txtEdat" and a text box "txttotal".
I have a table that is called "Call Logs" and a field in it called "Date" which is shown as mm/dd/yyyy for each record.



What i want to do is have "txttotal" display the # of records for the specific date range when the user enters it into "txtSdate" and "txtEdate"


- Any help would be great!
Thanks.

[ranman256]

select * from tCallLogs where [date] between forms!frmFind!txtSDate and forms!frmFind!txtEDate

for total either look at the bottom record count
or make the query do the count instead of individiual records.