Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / March 2005

Tip: Looking for answers? Try searching our database.

zero instead of Null?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Coldeyes - 11 Mar 2005 15:57 GMT
I have to show outstanding quantities of deliveries for orders. There is no
problem if there was a partial delivery: outstanding=ordered-delivered. In
case of orders where there was no delivery at all, the field delivered
contains no value i.e. null. Accordingly the field outstanding has no value
either although it should show the quantity ordered. How can I solve this
task? Should I have zero in the field delivered, and if yes, how?

Thank u very much for your kind assistance.
Marshall Barton - 11 Mar 2005 16:16 GMT
>I have to show outstanding quantities of deliveries for orders. There is no
>problem if there was a partial delivery: outstanding=ordered-delivered. In
>case of orders where there was no delivery at all, the field delivered
>contains no value i.e. null. Accordingly the field outstanding has no value
>either although it should show the quantity ordered. How can I solve this
>task? Should I have zero in the field delivered, and if yes, how?

Just use the Nz function around the delivered field in the
expression:

    Outstanding = Ordered - Nz(Delivered, 0)

Signature

Marsh
MVP [MS Access]

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.