Telefon: 035179593513

SQL extend a Recordset / VBA DAO etc.

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:

 

and if you want to add a entry without insert then you can union like: