I have a DB that takes a quote number and turns it into an order using the same Quote number as the order number. I have added a quote number field to the order table and need to copy all of the current order numbers to the new field in the same table.
I can't seem to get the update query to update the records.
In the Update to field in for the quotenumber field , I have =[ordernumber] but it doesn't work. I have tried putting null in the criteria field since that field is empty. still doesn't work
I need to do this so I can keep all of my code written and just add the quote number field, from here forward there will be a different number the orders and quotes.
Trying to fix a bad design from the start.
Thanks
I can't seem to get the update query to update the records.
In the Update to field in for the quotenumber field , I have =[ordernumber] but it doesn't work. I have tried putting null in the criteria field since that field is empty. still doesn't work
I need to do this so I can keep all of my code written and just add the quote number field, from here forward there will be a different number the orders and quotes.
Trying to fix a bad design from the start.
Thanks
Last edited: