append qry .- simple (I hope)

[GaryPanic]

Hi guys not been around for a while -
simple problem

I want to append records from one table (A) to table the same table - but...
change the one field only

So I have quoteno 12345 with say 30 records in a child table
(Ac) and I want to create quoteno 45678 and copy those records in to the same table (Ac)

reason quote no is different product one is say Gas and product two is water
two different products but the underlying information

the suppler are different data the same
what i had in mind was to go to the new quoteno 45678 and copy the child data from 12345
i have a field on the quote called copyquote - enter in the ref I want to copy and past in to the child table with the ref 45678 (replacing the 12345 ref on the append)
:banghead:
blond moment

 

[plog]

Kind of lost me the more you explained, so I focused on this:

I want to append records from one table (A) to table the same table - but...
change the one field only

To achieve that you would create a query in design view, bring down all the fields individually into the bottom section. Change the query to an APPEND in the ribbon and choose the appropriate table. Then back in the bottom section find the one field you want to change the value of and replace it with a field like so:

NewValue: "YourNewValueHere"

Run that and it will add the correct number of rows with the new value for that field.

And of course step 1 of any update like this is to make a backup of the table you will be acting on.

 

[GaryPanic]

I ramble -
got to most of this - no problem the new value bit is the one that's thrown me

NewValue: "YourNewValueHere"


i want the new value to be a field on my current form
so New value :=form!formName!Formfield

its this bit that i am brain dead on

 

[plog]

Try this:

NewValue: [Forms]![YourFormName]![YourFormFieldName]

 

[GaryPanic]

no just a blank ...

its just getting the "new" number that's a puzzle

 

[plog]

I don't understand. Don't you know the new value?

 

[GaryPanic]

yes its the value on the form - but it will not automatically populate the field Newvalue

 

[pbaldy]

Sounds like you want to do this:

http://allenbrowne.com/ser-57.html

 

[GaryPanic]

yep - that's what i need to do -

I tweak it to fit
tried to do it with simple queries -failed

however this looks the thing

cheers

G

 

[pbaldy]

Happy to help.