G
Guest
I have a large database of apparel items with which I am attempting to do a
quoting system.
Using queries and a macro, I can get whatever list of items from the large
database into another table, along with the number of colors to print front &
back.
Now I have a table with about 15 items all with the same part number.
I want to have a field called quantity which the user would input with the
quantity of items on which to quote. I need to fill all of the records with
the same quantity, using user input only one time. With a quantity of 50
all 15 records would change to 50 in the quantitiy field with the user only
typing in 50 once. I have tried using a parameter input like I did for the
part number and the colors to be printed, using an update query, however this
did not work.
Any help would be appreciated!
Rick
quoting system.
Using queries and a macro, I can get whatever list of items from the large
database into another table, along with the number of colors to print front &
back.
Now I have a table with about 15 items all with the same part number.
I want to have a field called quantity which the user would input with the
quantity of items on which to quote. I need to fill all of the records with
the same quantity, using user input only one time. With a quantity of 50
all 15 records would change to 50 in the quantitiy field with the user only
typing in 50 once. I have tried using a parameter input like I did for the
part number and the colors to be printed, using an update query, however this
did not work.
Any help would be appreciated!
Rick