Hi all,
I have an access table and one of the field is entrydate (date and time is the datatype) field. I have customer id also.
For everyday transaction I need to know whether the customer is calling for second time.
I created query select * from [table name] where customer_id = '" & txtcid & "' and
*****(entrydate) = #'" & Date & "'#

ie. I am referring the date as the system date.
Now my porblem is how to convert the database [date and time ] field into a date
for my query .
anyone help me please
My advance thanks.

karun