Replies

Thanks

This is the query to work out all employees worked hours

SELECT [A Walton time step 2].SumOfExpr1, .SumOfExpr1, [D Brooks time step 2].SumOfExpr1, [D Cantelo time step 2].SumOfExpr1, [D Gough time step 2].SumOfExpr1, [D Powell time step 2_1].SumOfExpr1, [G Owen time step 2_1].SumOfExpr1, [K Jones time step 2_1].SumOfExpr1, .SumOfExpr1, [j smith time step two].SumOfExpr1
FROM [A Walton time step 2], , [D Brooks time step 2], [D Cantelo time step 2], [D Gough time step 2], [D Powell time step 2], [G Owen time step 2], [K Jones time step 2], , [D Powell time step 2] AS [D Powell time step 2_1], [G Owen time step 2] AS [G Owen time step 2_1], [K Jones time step 2] AS [K Jones time step 2_1], AS , AS , [j smith time step two];

As you can see it uses previous queries, an example of which is below

SELECT Sum([A Walton time step 1].Expr1) AS SumOfExpr1
FROM [A Walton time step 1];

And the first query in the string

SELECT [Downtime data for time based queries].[Repair Carried out by], [Downtime data for time based queries].[Assisted by 1], [Downtime data for time based queries].[Assisted by 2], [Downtime data for time based queries].[Assisted by 3], (DateDiff(‘n’,[Downtime data for time based queries]![Repair Started],[Downtime data for time based queries]![Repair Completed]))/60 AS Expr1
FROM [Downtime data for time based queries]
WHERE ((([Downtime data for time based queries].[Repair Carried out by])=”A. Walton”)) OR ((([Downtime data for time based queries].[Assisted by 1])=”A. Walton”)) OR ((([Downtime data for time based queries].[Assisted by 2])=”A. Walton”)) OR ((([Downtime data for time based queries].[Assisted by 3])=”A. Walton”));

The second of the queries I’m trying to calculate from is this one

SELECT [Total Clocked hours].[Brooks, D#], [Total Clocked hours].[Cantelo# D#], [Total Clocked hours].[Firth, S#], [Total Clocked hours].[Gough, D#], [Total Clocked hours].[Jones, K#], [Total Clocked hours].[Owen, G#], [Total Clocked hours].[Parrish, B#], [Total Clocked hours].[Smith, J#], [Total Clocked hours].[Walton, A#]
FROM [Total Clocked hours]
WHERE ((([Total Clocked hours]![Week Number])=37));

I know this is a bit of a roundabout way of doing this, but without learning to use code it’s the only way I am capable of getting these two answers. Besides, it didn’t take long to set up and works

Thanks for the information, I’ll check out my local library for copies of the two books recommended, have a read before buying to make sure they will help me.

I’m assuming that those of you who replied had some previous programming experience?? If so, will these books work on a complete programming novice? But then, guess I’ll find that out in the library )