Recent content by STEVEGARDNER
-
S
re; Null Values
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...- STEVEGARDNER
- Thread
- Replies: 3
- Forum: Queries
-
S
RE; DSum within a Subform problem
Yeah, that worked thanks... guess i was trying to over complicate things with a DSum? Steve- STEVEGARDNER
- Post #3
- Forum: Forms
-
S
RE; DSum within a Subform problem
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...- STEVEGARDNER
- Thread
- Replies: 2
- Forum: Forms