If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
in access, if then statement
if (Escalation/Assignment = 0) or (Updateheat = 0 )or (Worklog = 0), then 0
for the total. Else total. How would you set this up in design query? Each of the above is a seperate table Query: SELECT DISTINCTROW tblMonitoringData_OLD.[HEAT ID], [tblEscalation/Assignment]![Points Earned]+tblUpdateHeat![Points Earned]+tblWorklog![Points Earned] AS [Documenation Pts], [tblEscalation/Assignment].[Points Earned] AS [Escalation?Assign], tblUpdateHeat.[Points Earned] AS UpdateHeat, tblWorklog.[Points Earned] AS Worklog FROM ((tblMonitoringData_OLD LEFT JOIN [tblEscalation/Assignment] ON tblMonitoringData_OLD.[Escalation/Assignment] = [tblEscalation/Assignment].ID) LEFT JOIN tblUpdateHeat ON tblMonitoringData_OLD.UpdateHeat = tblUpdateHeat.ID) LEFT JOIN tblWorklog ON tblMonitoringData_OLD.Worklog = tblWorklog.ID GROUP BY tblMonitoringData_OLD.[HEAT ID], [tblEscalation/Assignment].[Points Earned], tblUpdateHeat.[Points Earned], tblWorklog.[Points Earned]; |
Thread Tools | |
Display Modes | |
|
|