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: *

  1. Vet246

    Display null as blank

    When I display the field with no formula the field displays the null values as 0.00. When I use the first formula that I have listed it still displays the null values as 0.00.
  2. Vet246

    Display null as blank

    I've also tried the following formulas with no success: If isnull({TM_PGP.PG_ALW_1}) or trim (totext({TM_PGP.PG_ALW_1})) = "" then "N/A" else (totext({TM_PGP.PG_ALW_1})) If isnull({TM_PGP.PG_ALW_1}) then .33333 else {TM_PGP.PG_ALW_1} If not isnull({TM_PGP.PG_ALW_1}) then {TM_PGP.PG_ALW_1}...
  3. Vet246

    Display null as blank

    In the formula field I have Exceptions for Nulls
  4. Vet246

    Display null as blank

    I my settings the options are: 1. Convert Database Bull Values to Default 2. Convert Other Null Values to Default I do not have either of them checked. This field is a numeric field.
  5. Vet246

    Display null as blank

    I'm seriously stuck! I have a report where I'm trying to pull the null values in as 'blank' and the other values in as they are listed in the database. I can't pull the null values in as 0.00 because I have prices in the database that are 0.00. I've tried all of the following formulas and has...

Part and Inventory Search

Back
Top