MS Access: Concatenate recordset with different separators based on number of records
<p>How do I concatenate a recordset and have separators based on the number of records?  No separator for one record, “ and “ for two records, and commas between more than two records with “, and” before the last record. </p>