Set a SQL Result as Variable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!

Is there a way to set an SQL Result As Variable?
The reason why I want to do this, is because of a date comparison.
An example: if the date variable is 1-1-2007 and the other date variable is
also 1-1-2007 then .....

Is this possible?

Kind regards, Stefan van der Hooft.
 
You need to open a recordset, and refer to a specific field in a specific
row in that recordset. If your query only returns a single row, you should
be able to use DLookup.
 
Back
Top