in ado
you encase field values with special characters
numbers -> are bare
string and currency -> you use apostrophe
date -> you use pound sign
what would you use for
a) memo field
b) ole object field
i am using values from one recordset to populate a second recordset.
