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 Rhinorhino 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. base836ball

    using IIF and the AND statement

    OK what I have is a date field and a total field(which adds the total of 3 other text fields) What I am trying to do is if stock # is 1799512 then only add 2.5, and if the date is between 9/9/2005 and 11/9/2005 add 2.5, and if greater than 11/9/2005 then add 4.5. Here is what I have...

Part and Inventory Search

Back
Top