Search results

I have built a query from 2 tables tblPlannedOrders and tblPurchase Orders, the aim of the query is to show how much has been ordered against the planned amount from the budget. The query works only if something has been ordered against the Planned Order number, if there has been no order the...

Hi, I am having trouble trying to work out the correct formula to get a DSum working on my subform - "PObyVendor subform" I have a table called "Purchase Orders" and the field I am trying to sum is called [Total]. Entering the expression: =Sum ( "[Total]" , "Purchase Orders" ) Brings...