Repeat Records - Nothing Works!!!

R

Repeat records

I have a table called Maria.
With the following fields in: Field1,Price,Quantity Invoiced,Inv No, Invoice
Date

Field1 Price Quantity Invoiced Inv No
Invoice Date
BIG 3555
24/10/2003
IT1 1.99 5
BIG 3556
1/12/2003
IT1 2.99 10
IT1 1.99 15

For every instance in Field1 where 'BIG' is followed by 'IT1' I want to copy
the value of the records in fields Inv No and Invoice Date. This will leave
me with the following table:
Field1 Price Quantity Invoiced Inv No
Invoice Date
BIG 3555
24/10/2003 IT1 1.99 5
3555 24/10/2003
BIG 3556
1/12/2003
IT1 2.99 10 3556
1/12/2003
IT1 1.99 15 3556
1/12/2003

How do I do this using a query(using code)???
Manually I can use CTRL + (') but I have thousands of records.

Please Help!
 
Top