Minds Gone Blank!!!!!!!! Query Help

[Chimp8471]

i need to generate a query, that is as follows

Planned Time - Combi - Dolly Tray - Handle - Imaje - Misc - Palletiser - Straw - Tray

Divided by Planned Time

I have been trying to sort this all morning but cant sem to work it out.

there are a few things to consider.

The part of the above equation "Combi - Dolly Tray - Handle - Imaje - Misc - Palletiser - Straw - Tray"

this is time lost due to downtime for each group of equipment, this is determined by an "eventcode"

I was going to just group all the downtime together but it is a requirement that i have it split as above. so that i can display performance % for each piece of Equipment as well as a whole.


Attatchment Here

Hope this makes Sense.

Cheers

Andy

 

[Chimp8471]

I have just reread through my post and not sure it makes too much sense, i also tried my link and it doesn't seem to work.....great start.

i have now added a picture and a smaller database to show what i am trying to do.

i need help to try and get a query using the attached database that will give me the results similar to that in the attached picture.

i have tried loads of different ways but cant seem to get it to work.

please help

Andy