store the content of a field variable

F

Frank Dulk

As I do to store the content of a field of several records in a variable and
separating each record for a line
 
M

Michel Walsh

Hi,

? CurrentProject.Connection.Execute("SELECT OrderID FROM Orders WHERE
OrderID<=10251 ").GetString(,,",", ",", vbNullString)



Note that you will have to remove the extra ending coma, from the result.



Hoping it may help,
Vanderghast, Access MVP
 
Top