I'm trying to force a select query to return a record with default values IF the criteria does NOT find a matching value.
SELECT Field1 + Field2 + Field3 + Field4 AS TotalFields, UniqueID
WHERE (UniqueID = 'DM') AND (SomeDateField = '3/31/2004')
If the select does not return any records, I need it to be forced to return at least one record with default values (that I can specify).
Is this possible?