If you can email me I will give you a more detailed explanation, but here is my problem. I have a table in access, two of the columns change numbers every few records. eg.
first last add1 add2 1 1
first last add1 add2 1 1
first last add1 add21 2
first last add1 add2 1 2
first last add1 add2 2 1
first last add1 add2 2 1
first last add1 add2 2 1
first last add1 add2 2 2
ect… with the two columns,of just numbers,
I need to have a VB funtion that will copy each recordto a new table and enter a new record right before the record that has the changed number.It doesn’t matter which column changes , it would have the same effect. In this new record I am wanting to have all of the fields blank, except I am trying to put the “first” field in the “add1” column and the “last” in the “add2” column. So basically it would look like this:
first last add1 add2 1 1
first last add1 add2 1 1
first last
first last add1 add2 1 2
first last add1 add21 2
first last
first last add1 add2 2 1
first last add1 add2 2 1
first last add1 add2 2 1
first last
first last add1 add2 2 2
I would so appreciate if some VB expert could help me I have been trying to research this and just can’t figureout how to get it to work PLeeaassee help will give 2000 extra to someone who could do it before monday at 10 a, PT. TAhanx!!! thankyou all.
