store the content of a field variable

  • Thread starter Thread starter Frank Dulk
  • Start date Start date
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
 
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
 
Back
Top