| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
force a $0.00
I have a sheet that updates from an access database. I'm using the following
to bring a sum of sales for a date range. Some times, there may not be any records for that range and I would like it to show 0 instead of an empty cell. Here is my code. Thanks. SELECT Sum(`51002`.Total) AS '5-1002' FROM `\\web\web sites\lf\fpdb\mylf`.`51002` `51002` WHERE (`51002`.Date1 Between ? And ?) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can force enable macros to be able to open my workbook? | Excel Discussion (Misc queries) | |||
| force excel to run in only one process excel.exe | Excel Worksheet Functions | |||
| Percentage function formula | Excel Discussion (Misc queries) | |||
| Concatenate & Force argument to End of String-(spsjp) | Excel Worksheet Functions | |||
| concatenate, force new line | Excel Worksheet Functions | |||
Linear Mode
