include comma in name in results of VBA statement query
Posted on 2014-11-11
I have inherited a query that is created in VBA. It is a simply select statement, "SELECT RSM FROM tblRSM". Problem is that the names have a comma, for example, Smith, Sandra. When the code runs the query, it recognizes the value in field(0), BUT it then assumes the value after the comma is field(1). How do I get it to recognize the entire name value rather than it automatically assuming the value after the comma is another field?