Set a SQL Result as Variable

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

Douglas J. Steele

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Upload files through an Access form? 3
Check if data already exists in database. 3
Results of SQL select assign to variable 0
Open a MDI file 1
TransferSpreadsheet to a protected Excel-sheet 3
Cell is "Last value" in range 2
Use a Variable to set a Variable 13
Check if an specific Excel file is open before transfer spreadshee 2

Top