How to add multiples records from a querie

[Marco]

Hi.

I have a unmacth querie that inserts me into a table the records that are
note match.

My problem is that when I have one one unmatched record i need to insert
that record 12 times. I have to insert 12 time each record that I have
diferent.

What happens is that anytime I insert a record I have a repeat it 12 times
so I can have:

Periodo:
1
2
3
4
5
6
7
8
9
10
11
12

All the fields are equal but the this filed must be diferent.

I can I insert 12 records automatically?

Regards,
Marco

 

[KARL DEWEY]

Try creating a table named Period with a field named period containing
numbers 1 (one) through 12 (twelve). Add table Period to your append query
with out joining.
Use [Period].[Period] to insert to Periodo.