Search results
-
C
Trouble with my SQL in GAGEpack
This report writing software, GAGEpack, is syntactically correct according to the SQL standard for Microsoft Access. This software doesn't really give error messages so I have no indication of what is actually wrong with the report. The bolded statements is where I am having issues. I don't know...- cpascual
- Thread
- Replies: 0
- Forum: Other Software
-
C
Fairly New to SQL and now trying a bit more complicated coding
FROM ((((((Gages LEFT JOIN Events ON Gages.GageId=Events.GageId) LEFT JOIN EventType ON (Events.EventType=EventType.Type)) LEFT JOIN EventCalib ON (Events.EventID=EventCalib.EventID)) LEFT JOIN EventRepair ON (Events.EventID=EventRepair.EventID)) LEFT JOIN EventMaint ON...- cpascual
- Post #3
- Forum: SQL Server
-
C
Fairly New to SQL and now trying a bit more complicated coding
I am using a database software known as GAGEpack, it is syntactically correct according to the SQL standard for Microsoft Access. I just had to start using the IIF command and I am fairly confident in using it on a small scale. In the coding below I am using multiple nested IIFs and I am trying...- cpascual
- Thread
- Replies: 2
- Forum: SQL Server