Text box contains #Error regarding sum value

[Chlaris]

Dear all,

I have a main form and subform

Main form : frmListInvoiceMain
Subform : frmListInvoiceDetail

In the form footer of frmListInvoiceDetail, I have a text box :

Name : txtSumOfAmount
Control Source : =Sum([Amount])

In the form footer of frmListInvoiceMain, I have a text box :

Name : txtTotal
Control Source : =[frmListInvoiceDetail].[Form]![txtSumOfAmount]

The record source of frmListInvoiceDetail is retrieved from union query.

If there are record(s) in the subform, txtTotal works fine.
But if there is no record in the subform, txtTotal return #Error

How to solve this problem ?
Thanks.

Chlaris

 

[boblarson]

Use the NZ function:


Name : txtSumOfAmount
Control Source : =Sum(Nz([Amount],0))

 

[Chlaris]

Using the NZ function doesn't work.
Thanks.

Use the NZ function:


Name : txtSumOfAmount
Control Source : =Sum(Nz([Amount],0))


--
Bob Larson
Access World Forums Super Moderator
____________________________________
If my post was helpful to you, please rate the post.

Dear all,

I have a main form and subform

Main form : frmListInvoiceMain
Subform : frmListInvoiceDetail

In the form footer of frmListInvoiceDetail, I have a text box :

Name : txtSumOfAmount
Control Source : =Sum([Amount])

In the form footer of frmListInvoiceMain, I have a text box :

Name : txtTotal
Control Source : =[frmListInvoiceDetail].[Form]![txtSumOfAmount]

The record source of frmListInvoiceDetail is retrieved from union query.

If there are record(s) in the subform, txtTotal works fine.
But if there is no record in the subform, txtTotal return #Error

How to solve this problem ?
Thanks.

Chlaris

 

[boblarson]

Have you figured this out? I am surprised that the NZ function did not work
for you. But, if it didn't then are you sure that your text box that houses
AMOUNT is named differently than the field?
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

Using the NZ function doesn't work.
Thanks.

Use the NZ function:


Name : txtSumOfAmount
Control Source : =Sum(Nz([Amount],0))


--
Bob Larson
Access World Forums Super Moderator
____________________________________
If my post was helpful to you, please rate the post.

Dear all,

I have a main form and subform

Main form : frmListInvoiceMain
Subform : frmListInvoiceDetail

In the form footer of frmListInvoiceDetail, I have a text box :

Name : txtSumOfAmount
Control Source : =Sum([Amount])

In the form footer of frmListInvoiceMain, I have a text box :

Name : txtTotal
Control Source : =[frmListInvoiceDetail].[Form]![txtSumOfAmount]

The record source of frmListInvoiceDetail is retrieved from union query.

If there are record(s) in the subform, txtTotal works fine.
But if there is no record in the subform, txtTotal return #Error

How to solve this problem ?
Thanks.

Chlaris

 

[Chlaris]

The sum text box works fine if there is any record in the subform.
Thx.

Have you figured this out? I am surprised that the NZ function did not
work
for you. But, if it didn't then are you sure that your text box that
houses
AMOUNT is named differently than the field?
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

Using the NZ function doesn't work.
Thanks.

Use the NZ function:


Name : txtSumOfAmount
Control Source : =Sum(Nz([Amount],0))


--
Bob Larson
Access World Forums Super Moderator
____________________________________
If my post was helpful to you, please rate the post.


:

Dear all,

I have a main form and subform

Main form : frmListInvoiceMain
Subform : frmListInvoiceDetail

In the form footer of frmListInvoiceDetail, I have a text box :

Name : txtSumOfAmount
Control Source : =Sum([Amount])

In the form footer of frmListInvoiceMain, I have a text box :

Name : txtTotal
Control Source : =[frmListInvoiceDetail].[Form]![txtSumOfAmount]

The record source of frmListInvoiceDetail is retrieved from union
query.

If there are record(s) in the subform, txtTotal works fine.
But if there is no record in the subform, txtTotal return #Error

How to solve this problem ?
Thanks.

Chlaris