Null Value problem in query

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / Reports / Printing / June 2005

Null Value problem in query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LJG - 30 Jun 2005 21:02 GMT

Hi Guys,

How can I change this expression to add 0 to any null values?

soflinesum: Sum([qty]*[price])

TIA
Les

Reply to this Message

nospam.com - 30 Jun 2005 22:04 GMT

>How can I change this expression to add 0 to any null values?
>
>soflinesum: Sum([qty]*[price])

Sum(Nz(qty*price,0))

Reply to this Message

Marshall Barton - 01 Jul 2005 00:32 GMT

>How can I change this expression to add 0 to any null values?
>
>soflinesum: Sum([qty]*[price])

You should not have to do that because the aggregate
functions ignore null values in their calculations.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

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.