stupid dates

[lostlobo]

I have a table set up mistransfer_details and am trying to create a report on this table based on date. This seems so stupid I have read tons of articles and still it does not work. I have a report, and on the form I have two text boxes and a button when you press the button it calls a query and passes it to the do.openreport command like this

Reports_sql = "SELECT * " & "from mistransfer-details"
DoCmd.OpenReport "mistransfer-details", acViewPreview, "(([mistransfer-details].date_sub)>= #" & Me.txtstart.Value & "#) and (([mistransfer-details].date_sub)<=#" & Me.txtend.Value & "#)"

but I always get the same thing every single record from every single date? any ideas I have tried everything i can read

 

[lostlobo]

never mind as always I post a question and the then relize my mistake same all througth school to, hey prof can't get this opps never mind! ug!!! thanks again