>I have a database (regular table) that has records in it sorted by a field called "customerid".
The "customerid" field identifies the customer ID number of individual records. There are multiple records with the same customer ID number. I want insert two empty/blank records after each group of records with the same customer ID number.
>
>What is the code to do that?
William,
Quite simple really, and many ways to do it.
xCustID = However_you_get_it && must not be a primary key (PK) i.e. unique
Inset into CustTable ( CustomerID) values ( xCustId)
Inset into CustTable ( CustomerID) values ( xCustId)
HTH
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.