error in formula in report

[Guest]

I get Error# when there is no amount for the TotalRequsition in the
following formula:
[StartingAccBalance]-[totalRequisitions]-[TotalPayroll]

Some accounts do not have reqs and others do not have payroll. However some
accounts have both. Any suggestions?

Thanks

 

[Douglas J. Steele]

[StartingAccBalance]-Nz([totalRequisitions],0)-Nz([TotalPayroll],0)

 

[RuralGuy]

I get Error# when there is no amount for the TotalRequsition in the
following formula:
[StartingAccBalance]-[totalRequisitions]-[TotalPayroll]

Some accounts do not have reqs and others do not have payroll. However some
accounts have both. Any suggestions?

Thanks

Use the Nz() function.
Nz([StartingAccBalance],0)-Nz([totalRequisitions],0)-Nz([TotalPayroll],0)
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[Guest]

Can you use this to reference a subreport?

Ex: =NZ([totalPayroll].Form!TotalPayroll,0)

Thanks....

[StartingAccBalance]-Nz([totalRequisitions],0)-Nz([TotalPayroll],0)



--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I get Error# when there is no amount for the TotalRequsition in the
following formula:
[StartingAccBalance]-[totalRequisitions]-[TotalPayroll]

Some accounts do not have reqs and others do not have payroll. However
some
accounts have both. Any suggestions?

Thanks

 

[Douglas J. Steele]

You can't reference a subreport: you'd have to reference a control on the
subreport, but yes, you can do that.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Can you use this to reference a subreport?

Ex: =NZ([totalPayroll].Form!TotalPayroll,0)

Thanks....

[StartingAccBalance]-Nz([totalRequisitions],0)-Nz([TotalPayroll],0)



--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I get Error# when there is no amount for the TotalRequsition in the
following formula:
[StartingAccBalance]-[totalRequisitions]-[TotalPayroll]

Some accounts do not have reqs and others do not have payroll. However
some
accounts have both. Any suggestions?

Thanks