Sum filtered records that produce no results

R

Ryan Tisserand

Access 2003
Vista Business
Form Name - C25Transactions
Subform1 Name - C25TransactionsSF
Subform2 Name - C25DepositsSF

My question is this. I have filter controls at the top of the
C25Transactions, and sometimes all of the records are filterd out of
C25DepositsSF. I have a calculation in C25DepositsSF, and then a textbox
that equals that calculation in C25Transactions. If there are no records
then the textbox reads #Error. I have tried the use of Null, "", using
0+(sum), but to no avail. Is there a way to make the field read 0 instead of
Empty so the calculations on C25Transactions will total instead of reading
#Error?
 
R

Ryan Tisserand

Sorry to bother. I figured out my own solution.

=IIf(IsError(C25DepositsSF.Form!TotalDeposit),0,(C25DepositsSF.Form!TotalDeposit))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return "No Matching Records" 2
Refer to a Sum in Subform2 from Subform1 4
Null Value in Subform Total 4
Filtered Records as source for appending records to a table 1
Calculated control not displaying zero when recordset is empty on 5
Sum records to a textbox 2
Access Sum function in an Access Form 1
Modifying/Appending records between subforms 2

Top