Copy a date from a table into a variable

[Guest]

I have a table that contains one record and two fields. Both fields contain
dates. How can I most efficiently copy one of these dates into a variable?

FYI the SQL to do this would look like this:

SELECT [DATE_FROM] FROM [RUN_DATE];

But, how can I copy the result into a variable in a module?

Thanks in advance.

 

[tina]

try

MyVariable = DLookup("DATE_FROM", "RUN_DATE")

hth