Referencing a single field in an ADO recordset

P

PFMcCracken

How to reference a single field in an ADO recordset? I need to compare the
date in the current record and then grab it in the next record. But I am
not sure how to do this in MC Access.
 
M

MGFoster

Read a value from an ADO recordset (assume you're using VBA):

dim rs as new adodb.recordset
' ... etc. ... open recordset

Debug.Print rs!date_field_name ' Displays specific field value
 
Top