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!

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

Recent content by Skip1961

  1. Skip1961

    Simple if statement won't work

    Hilfy, exactly correct. Thank you. A lot!
  2. Skip1961

    Simple if statement won't work

    Nulls, if any, don't seem to bother it. The @citystzip formula works just fine when I place the formula on the report like a database field and call it directly. "Chicago, IL 34567". It fails when I put the " if > 7 and < 19 " language in front of it. Seems like I should get the "if" or the...
  3. Skip1961

    Simple if statement won't work

    I know this is terribly basic, but I can't get by it. I have created a formula named @citystzip. It is constructed of the three obvious fields: {tsworking.city} + ", " + {TSWorking.State} + " "+ {TSWorking.Zip} But now I want the format to be different based on a country code in a field in...

Part and Inventory Search

Back
Top