Recent content by cpascual

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...

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...

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...