I have a query that produces a set of records that then feed a report. The report is used by others to collect more information about known points (the subject of the report) in the field. Usually, the person using the report needs to enter new points by hand that are then entered into the database.

Is it possible to write a query that finds specific records and that allows one to insert "blank" records as well?. Or, can an insert query be written that would allow a previous query result to act as a table?

I am exploring this route because it would allow me to continue the report formatting more easily.

Thanks in advance.