I need to retrieve a set of records with 5 fields in the recordset.
I need to append an extra field to this retrieved recordset.
MS says this is not possible, at least not using APPEND.
Any other ideas (other than the obvious idea of copying all data to a new recordset, field by field...)
I would really prefer some sort of an example, if possible.