Unless you have time and patience don't bother with this question.
I am a novice with Access so I will ask lots of questions and need lots of direction. I have eliminated some data to reduce the file size and I think everything still works. Also I know my table are the best set up so any advice in that direction would be greatly appreciated also.
I have an excel sheet which I have put into Access so I can hopeful build some reports on.
I am trying to separate the data into different tables.
The data concerns Equipment and the routine maintenance for each piece of equipment.
My biggest obstacle is building a report which shows a count for how many times a certain PM occurs.
The unique identifier for the equipment is 'AssetName'
The routine maintenance is set up as follows:
Each unique task has a 'TaskNum'
These are grouped by 'PM_NUM' - This grouping identifies what tasks are in a grouping.
Additional grouping was them done and the main grouping is 'TaskCombo'
On my report 'rpt_TasksGrouping_Counts'
I need to get a count of how many times 'TaskCombo' occurs by Trade and then get a total duration.
The report is now showing how many lines of task there are in each 'TaskCombo' by Trade and the total duration by 'TaskCombo'
Example: Taskcombo SAPPM00010 occurs only once, it has 4 lines of tasking, each line requires 0.0001 for duration and it is for the 'O' (Operator Trade).
I would like it to show the following:
SAPPM00010 occurs 1 time for Trade 'O' for a total duration of 0.0004
Also I will be AWK for 15 hours.