help

[alxw3 via AccessMonster.com]

I have a table that looks like this:
ID X X X X
it should append to a table that looks like:
ID X
ID X
ID X
, and so on.
my destination table is a linked list?.
my append query fails at From.

insert inot LinkedTable (ID, Field2, Field3)
SELECT ID, 'Name' AS Field2, Name AS Field3
FROM Table1
UNION
SELECT ID, 'Address' AS Field2, Address AS Field3
FROM Table1
UNION SELECT ID, 'Age' AS Field2, Age AS Field3 FROM Table1;

my other questions:
1. how about if my destination table was not a linked table.
2. what is best way to automate this append as part of a scheduled task?.

 

[KARL DEWEY]

It seems funny you want to change data to this type of table --- but I would
use a union query followed by an append query instead of trying to do it in
one.

 

[alxw3 via AccessMonster.com]

why is it funny?.

It seems funny you want to change data to this type of table --- but I would
use a union query followed by an append query instead of trying to do it in
one.

I have a table that looks like this:
ID X X X X

[quoted text clipped - 17 lines]

1. how about if my destination table was not a linked table.
2. what is best way to automate this append as part of a scheduled task?.

 

[KARL DEWEY]

The name, address, age (or better is DOB), gender, etc belong in a single
record rather in multiple records as you are wanting to do.

why is it funny?.

It seems funny you want to change data to this type of table --- but I would
use a union query followed by an append query instead of trying to do it in
one.

I have a table that looks like this:
ID X X X X

[quoted text clipped - 17 lines]

1. how about if my destination table was not a linked table.
2. what is best way to automate this append as part of a scheduled task?.