UPDATE tblDeals SET MoneyNow = 
(SELECT DSum ("[InvoiceAmount]", "tblInvoices") WHERE MonthCount = (select MAX(Period) from tblDeals) GROUP BY MonthCount) - 
(SELECT DSum ("[InvoiceAmount]", "tblInvoices") * 0.35 WHERE MonthCount = (select MAX(Period) from tblDeals) GROUP BY MonthCount) - 
(SELECT DSum ("[ExpenseAmount]", "tblExpenses") FROM WHERE ExpenseCategory <> 'Фонд развития' AND MonthCountMinus = (select MAX(Period) from tblDeals) GROUP BY MonthCountMinus) - 
((SELECT DSum ("[InvoiceAmount]", "tblInvoices") WHERE MonthCount = (select MAX(Period) from tblDeals) GROUP BY MonthCount) - (SELECT DSum ("[InvoiceAmount]", "tblInvoices") * 0.35 WHERE MonthCount = (select MAX(Period) from tblDeals) GROUP BY MonthCount) * 0.4

Ребят, совершенно не шарю в Access SQL. Помогите пожалуйста переделать запрос, чтоб он стал рабочим.

http://www.sql.ru/forum/1089202/dsub