troubleshooting Question

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

Avatar of ES-Components
ES-ComponentsFlag for United States of America asked on
Microsoft Access
4 Comments1 Solution415 ViewsLast Modified:
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
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros