I'm using a function to populate a column in a query. I essentially need to take all the records from one table that match the primary key in another and populate the query's column with them.
This is what I have:
Now this will return a number of records, from which I need to extract the first field of each (using rst.Fields(0).Value I presume).
My problem is that I can't work out how to cycle through the records.
Any help??? I'm totally stuck.
TIA,
Jordan
This is what I have:
Code:
strsql = "big SELECT query returning three fields"
dim rst as ADODB.Recordset
set rst = CurrentProject.Connection.Execute(strsql)
Now this will return a number of records, from which I need to extract the first field of each (using rst.Fields(0).Value I presume).
My problem is that I can't work out how to cycle through the records.
Any help??? I'm totally stuck.
TIA,
Jordan