I know how to do an append query from one table to another, but can't figure
out how to do the same thing with just one table. How do you run a query and
auto fill different rows in the same table? A select query seems to need two
tables and although I can set up an append query and select different fields
in different rows to append data, I get key violations, etc.

Thanks,
--
Julian

If you are using an autonumber for key field then just append those fields
you need but not the key field.

"Julian" wrote:

> I know how to do an append query from one table to another, but can't figure
> out how to do the same thing with just one table. How do you run a query and
> auto fill different rows in the same table? A select query seems to need two
> tables and although I can set up an append query and select different fields
> in different rows to append data, I get key violations, etc.
>
> Thanks,
> --
> Julian