Sometimes you will get a problem if you want to add a data entry to a recordset, it can be done without the need of inserting the data entry to the table.
It is a little bit tricky but with a union statement you can do following:
your normal statement looks like:
select Field1,Field2 from tableName;
and if you want to add a entry without insert then you can union like:
select Field1,Field2 from tableName union select '*' as Field1, 'All' as Field2 from tableName;