Append query Question

[sir_aingeal]

Is it possible to use an append query to take data from a linked table and append different fields into 3 different tables. Or do I have to use 3 different queries to do this and then run them consecutively either through code or a macro.

 

[FoFa]

The later.