I want to change [Forms]![COPBD]![cboDateFrom] to use the start date in the query.
POPBal: Sum(IIf([Purchase Date] Between [Forms]![COPBD]![cboDateFrom] And [Forms]![COPBD]![cboDateTo],(([Purchase Price]*[Purchase Qty]))-[Payment Made],0))
Temporarily I am using the following.
POPBal: Sum(IIf([Purchase Date] Between #1/1/1900# And [Forms]![COPBD]![cboDateTo],(([Purchase Price]*[Purchase Qty])),0))
What is the exact way to write this.