Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: DLeit
  • Order by date
  1. DLeit

    Summing w/ Null values on Reports

    Yes, you are correct this is an issue with subreports that don't return any records. How can I get my SUM to work when there are no records to sum? Do I have to work back into the original Query to set something up to return a record populated with a zero? You are right now that I think about...
  2. DLeit

    Summing w/ Null values on Reports

    I am trying to sum Subreports on a Master report. If I have a field come back as a null value in any of the subreports, I get the wonderful #Error. I am fine as long as there are no Null values. Is there a way to set my null values on my subreports to zero or tell the summing fuction that if...

Part and Inventory Search

Back
Top