append queries

  • Thread starter Thread starter S.Dickson
  • Start date Start date
S

S.Dickson

i have this append query its working apart from one bit

for the field Manufacure ID, I would like it to get the number from the
form i am on
How do i get it set up in the query that when it appends all the data
to the new table is also puts ManufactureID number next to all the
recores



[Forms]![frmManufactureTub]![ManufacuterID]
 
Use a calculated field in the query where the entry for Field: is [Forms]!
[frmManufactureTub]![ManufacuterID]
Access will probably give it a name like Expr1:
Then select the proper field in the Append To: section.

If you want to do something more, you can use a string function or math:
"Something " & [Forms]![frmManufactureTub]![ManufacuterID]
[Forms]![frmManufactureTub]![ManufacuterID]*10


i have this append query its working apart from one bit

for the field Manufacure ID, I would like it to get the number from the
form i am on
How do i get it set up in the query that when it appends all the data
to the new table is also puts ManufactureID number next to all the
recores

[Forms]![frmManufactureTub]![ManufacuterID]
Click to expand...
 
Back
Top