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 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: *
- Users: jeronimus1980
- Order by date
-
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...- jeronimus1980
- Post #10
- Forum: Microsoft: Access Other topics
-
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...- jeronimus1980
- Post #7
- Forum: Microsoft: Access Other topics
-
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...- jeronimus1980
- Post #4
- Forum: Microsoft: Access Other topics
-
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)...- jeronimus1980
- Thread
- Replies: 9
- Forum: Microsoft: Access Other topics
