I have a view (Access .adp fronte end and SQL Server back) that
retrieves a currency field from a table that is sometimes a NULL
value. That view is the RowSource for a List box that displays the
results. I want the List Box to show that field as 0 instead of
leaving it blank if the underlying table field is NULL. I can't use
the IIf or NZ function in a view. How can I do this?! TIA!
BTW - I MOSTLY need it because I SUM that List Box Column and display
it in a text box on the form. Obviously, without the 0 for the NULLS,
the SUM is wrong. Thanks again!