Hi I would like to be able to update the attached access database ad-hoc with an update qry but not at all sure where to start.
I want the database to multiply the Qty field as below replacing the value in the qty field with the new calc.
Only when type = Sales order
if Items status name = F/O Only * Qty field by 0.85 (rounded) up to the nearest whole number
If item status name = open * Qty field by 0.95 (rounded ) up to the nearest whole number
The qty field remains as is for anything not matching above