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 dencom 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. AndreaEllis

    Exclude Data Based By Year of Existance

    We have a table that has dummy data to make sure every page of our cross tab has every line item whether is real data or not. The problem is that I do not want the dummy data if we do not have current year real data. This report has previous year also. I need 1965 and 2013 if 2014 exists...
  2. AndreaEllis

    If Then Else help String versus Number

    I have a formula I am trying to write... If {field} (which is a number) = {Field2} (which is a string. I need to pull the first 4 characters from the second field) then {field 3} else {field 4} I am having an issue getting the field and field 2 to work like I am thinking it should. Andrea

Part and Inventory Search

Back
Top