Unanswered: Query help - don't know where to start!
I have a table structure that is out of my control that I need to query. It is a table that holds information about staff activity in the morning, afternoon and evening of each day of the week. Fields as follows:
Date (the monday of the week in question)
Each of these fields can have several results in them including:
I want to run a query (or queries) that ends up giving me a table that has a line for each UserID with
UserID, TOTALDAYS, OT, Admin, Train, Sick, Hols where each of the types is a total for a time period (usually a month) and TOTALDAYS is the sum of the rest....
Any help would be much appreciated... I don't really know where to start.