johnwiseman
MIS
Hello.
Running the following code delivers the required results unless [qry Staff Task Volumes.[sumofvolumes] is "0".
This is due to [ActualMinsPersTask] divides [sumofvolume]/[sumoftime] and if [sumofvolumes] = "0" you cant divide the [sumofvolumes] figure by "0", you get an #error in [ActualMinsPerTask].
SELECT [qry Staff Actual Rate Child].[Staff Number], [qry Staff Actual Rate Child].[Task Code], [qry Staff Actual Rate Child].SumOfTime, [qry Staff Task Volumes].SumOfVolumes, [sumoftime]/[SumOfVolumes] AS ActualMinsPerTask
FROM [qry Staff Actual Rate Child] INNER JOIN [qry Staff Task Volumes] ON [qry Staff Actual Rate Child].[Task Code] = [qry Staff Task Volumes].[Task Code];
Thanks in advance for your help.
Running the following code delivers the required results unless [qry Staff Task Volumes.[sumofvolumes] is "0".
This is due to [ActualMinsPersTask] divides [sumofvolume]/[sumoftime] and if [sumofvolumes] = "0" you cant divide the [sumofvolumes] figure by "0", you get an #error in [ActualMinsPerTask].
SELECT [qry Staff Actual Rate Child].[Staff Number], [qry Staff Actual Rate Child].[Task Code], [qry Staff Actual Rate Child].SumOfTime, [qry Staff Task Volumes].SumOfVolumes, [sumoftime]/[SumOfVolumes] AS ActualMinsPerTask
FROM [qry Staff Actual Rate Child] INNER JOIN [qry Staff Task Volumes] ON [qry Staff Actual Rate Child].[Task Code] = [qry Staff Task Volumes].[Task Code];
Thanks in advance for your help.