Hi,
I want to make a query where it would first select all records that are newer than [StockTakeDate] and then it should update the [Units In Stock] by taking away [Quantity].
I've googled it and looked hard but unfortunately I can't get this to work.
Here is what i have done:
PLease correct me where i have gone wrong.
And i also want to know whether i would be able to add a record to another table with todays date on when this query is executed.
Thank you, your help is uch appreciated.
I want to make a query where it would first select all records that are newer than [StockTakeDate] and then it should update the [Units In Stock] by taking away [Quantity].
I've googled it and looked hard but unfortunately I can't get this to work.
Here is what i have done:
PLease correct me where i have gone wrong.
And i also want to know whether i would be able to add a record to another table with todays date on when this query is executed.
Thank you, your help is uch appreciated.
