Set a SQL Result as Variable

  • Thread starter Stefan van der Hooft
  • Start date
S

Stefan van der Hooft

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.
 
M

Michel Walsh

A DLookup? or a DCount, with a criteria, and test if the count is 0 (no
record matching the criteria) or not.

You can also open a recordset and walkthrough its records, peeking its
field(s) while you loop over.


Hoping it may help,
Vanderghast, Access MVP
 
Top