Hello All,

I need to pass a field value from an SQL statement into a variable in VBA. Can anyone help?

Example:
the below statement will show me what i need but i need to place into a variable so that it can be used else where within a function.

Select Date from datetable where date=#01/01/01#

Cheers