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. jeronimus1980

    SQL query Swith function

    IT WORKS! Found out that I had the column of table2 formatted as text eventhough it looked otherwise as I populated already with numbers. Guess a standard beginners mistake. Thanks you guys. made my life a lot easier today and got at least something done for a change :) After I finished this...
  2. jeronimus1980

    SQL query Swith function

    Thanks again, PHV: I tried your method but got an "#Error" in the access table under Process1. (When I changed the Table2.Y to a value it worked, but this is not what I wanted). Dhookom: As I just started with Access and sql last weekend so I have a hard understanding your code recommendation...
  3. jeronimus1980

    SQL query Swith function

    Thanks for the above replies. What is the difference between the "switch" and "IIF" function? I updated the function but still have trouble with the following: Why is the [table2.Y] not accepted in the IIF function as shown below: SELECT Table1.ton, Table1.X, Table2.Y...
  4. jeronimus1980

    SQL query Swith function

    Dear Reader, Hopefully somebody can help me with the following" (Apologies already in advance for the poor explanation of the problem due to the fact that I am still pretty unfamiliar with the access/sql terminology.) part of my script: (tonnes and X are already assigned)...

Part and Inventory Search

Back
Top