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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SLQ IIF Problem
Thanks, I believe your on the right track with the outer joins. Unfortunatly I can't change the structure of the databse, but it is essentially like your example. I tried several joins with your data but have not been able to do what I want. How but an example SQL statement, I think I can apply...- Camper1
- Post #5
- Forum: Microsoft: Access Project (ADP)
-
SLQ IIF Problem
I am trying to capture a multi level Bill of Material. The following is an example. Assembly JMW9527DAW Obsolete N Low Level Cd 0 Class YD Type M U/M EA WO 27 COMBO CONVECT Rev Date 2/13/04 Rev Lvl 0 Sts P A T...- Camper1
- Post #3
- Forum: Microsoft: Access Project (ADP)
-
SLQ IIF Problem
OS = Microsoft Windows 2000 Professional I'm querying a mainframe AS400 database to download to an Excel 2002 spreadsheet. The following works fine until I add the IIf statement. Error message in Excel VBA simply says syntax error, however when I run it in Access 2002 (Service Pack 2) gives the...- Camper1
- Thread
- Replies: 4
- Forum: Microsoft: Access Project (ADP)
