Referencing a single field in an ADO recordset

  • Thread starter Thread starter PFMcCracken
  • Start date Start date
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.
 
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
 
Back
Top