Need HELPPPPPP.... ASAP....plz

[Wen Lie]

Dear All,

I have questions about SQL Statements.
Does anybody know about opening database with date variable as its criteria ???

Let's say that I need to open UNDKT table. And the record that will be showed is the record which is input today.

My SQL Statements :

"Select * from UNDKT where input_date = " & DateValue(TglInput) & ""

Is it true ??? Or you guys have something in mind ????

Need Help ASAP...

BRgds,
Wen Lie

[Chris]

It should be like this.

"SELECT * FROM UNDKT WHERE input_date =#" & DateValue(TglInput) & "#;"