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 John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Update query - key violations?
I've been running an update query for months without issue. Today I started getting key violation errors and it will not perform the update. UPDATE tblExHist RIGHT JOIN tmpEXCPTDWN ON tblExHist.ExHistID = tmpEXCPTDWN.ExHistID SET tblExHist.ExHistID = tmpEXCPTDWN!ExHistID, tblExHist.ExDate =...- wvSusie
- Thread
- Replies: 7
- Forum: Microsoft: Access Queries and JET SQL
-
SQL Syntax Error
I know I'm missing some quotes in/around the IIf statement.. Would someone please show me the correct syntax? Install Info3: Concatenate("SELECT [Issue#] & ') INSTL''D: ' & [InstallDate] & IIf(IsNull([PartTOW]),"", '; TOW: ' + [PartTOW]) FROM tblCompAnal WHERE ExHistID = '" & [ExHistID] &...- wvSusie
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
-
Another Nested IIF Statement ?
Hoping someone can help with this wild and wooly IIF statement.. fields in table: 1aPN, 1aSN 1bPN, 1bSN 2aPN, 2aSN 2bPN, 2bSN I was using this statement in my query when I was only capturing info for 2 parts... Part Info: IIf([1aPN]="NONE","NONE",IIf([1aPN] Is Null,"",IIf([2aPN] Is...- wvSusie
- Thread
- Replies: 17
- Forum: Microsoft: Access Queries and JET SQL
