I have the following select statement below that works. The problem is if there are NO orders that are less than todays date I get this error message because there is nothing to sum. Is there a way to write the select statement that this error would NOT occur?
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'FormatCurrency'