Craig Cox wrote:

> 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.
>

You might try a union of the report query and another that selects some
number of blank fields of the appropriate datatype and sizes.

Cheers,

Ann