problem in sql

[snoopy22]

Hello guys,

I want to display data from a table where all records from the given
date -that the user will type on txtGivenDate(textbox) - until now be shown.
so i used this one:

"select * from transcation where date >" & txtGivenDate

it's not working... any ideas?

 

[pbaldy]

As solved on another site:

"select * from transcation where [date] > #" & txtGivenDate & "#"