asked on 9/3/2013

If an SQL statement returns no data how can I enter a value in a field?

Select Sum(ext-price) From ordertable
WHERE shipdate=date()

As long as the shipdate is equal to the current day the above select statement will Sum the ext-price field. That is okay. How do I fix the select statement to enter 00.00 in the ext-price field if there is no order for the current day?
This is being displayed on my webpage that uses Dreamweaver.

Obviously if the condition is not met there is no data to sum. So how do I fill in this field with zeros?

Any help would be appreciated
Thank you
Rick

Microsoft Access

Last Comment

Argenti

9/4/2013

ASKER CERTIFIED SOLUTION

Argenti

9/3/2013

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Argenti

9/3/2013

Or if you want to have the value formatted

SELECT FormatNumber(Str(IIf(Sum(ext-price) is Null, 0, Sum(ext-price))), 2) 
FROM OrderTable
WHERE shipdate=date()

Open in new window

ES-Components

9/4/2013

ASKER

Fantastic!!!! This code works perfectly. It is just what I needed
Thank you for your help.
RICK....
.

Argenti

9/4/2013

I'm glad you're happy! Thanks for the points.