Hi Lee,
Example as requested (does not contain whole query but gives the idea):
SELECT VHCWorkTable.id, VHCSalesTable.IDfromWorkTable, VHCSalesTable.AccountNumber, VHCWorkTable.AccountNumber, VHCWorkTable.RetailLabRate, VHCWorkTable.VATRate, VHCWorkTable.Other1Time, VHCWorkTable.Other2Time, VHCWorkTable.Other3Time, VHCWorkTable.Other4Time, VHCWorkTable.Other5Time, VHCWorkTable.Other6Time, VHCWorkTable.Other7Time, VHCWorkTable.Other8Time, VHCWorkTable.Other9Time, VHCWorkTable.Other10Time, ([Other1Time]*[VHCWorkTable.RetailLabRate])...