Copying date from DB to Var.

[Dayo312]

I Need to Open the DB "C:\Client.mdb"
In the "clients" table in the DB
there is a row called "Date"
I need to know how to copy the 1st record
of that row to a var...

Possable???

Thankyou!