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 IamaSherpa 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: n1coltsfan
- Order by date
-
ACCESS 2003 APPEND A PASS OR FAIL BASED ON NUMBERS BETWEEN A RANGE
This works on a sigle field, IIf([Valve seat depth1]<[low specs] Or [Valve seat depth1]>[High Specs],"Fail","Pass") This is what I want but it doesnt work, Expr1: IIf[Valve seat depth1!Valve seat depth2!Valve seat depth5!Valve seat depth6!Valve seat depth9!Valve seat depth10!Valve seat...- n1coltsfan
- Post #4
- Forum: Microsoft: Access Forms
-
ACCESS 2003 APPEND A PASS OR FAIL BASED ON NUMBERS BETWEEN A RANGE
I have 4 different intake valve numbers 1 2 3 4 each are associated with unique low specs and high specs and 4 different exhaust valve numbers 1 2 3 4 also with unique low and high valves and no matter what valves they use In-1 and Ex-3 I want the below formula to apply. Intake valves are...- n1coltsfan
- Thread
- Replies: 4
- Forum: Microsoft: Access Forms
-
SQL HELP
This data is in SQL 2000 and the Field Name is raw_payload I want to write a query that seperates this field by the '+' as a delimiter into 4 other fields a1 a2 a3 a4 or whatever in the same database. Any help would be awsome. raw_payload S9000+ UV+100.0000+0.0000 UV+101.0000+101.0000...- n1coltsfan
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Data Transformation Services
