PDA

View Full Version : Report from excel database ??



JAmanow
02-07-2011, 06:53 AM
I know it can be arranged but I just have to ask.
Problem to unlock:
I have the database containing about 6000 lines (serial number, batch number, date, description, location, time, person, time in decimal form)

Serial..batch date -------------- description,------------- location --- --time.... person --- Tim: decimal
12......3072706...2010-07-14.....Håltagning.i.extruderns ... ...FB122 ... .. 01:00 ... HJH ..... 0.04
437... 3342555..2010-07-27 ... External Service PPS ... ... ...FB177 ... .. 00:30 ... LKJ ... .0.02


The column description consists of approx. 40 unique standard descriptions.
I wish a report to be Key in in another tab that can figure out all the unique description of the summation of time for each of the description.

Jan Karel Pieterse
02-07-2011, 07:15 AM
I'd use a Pivot table (if I understood your question correctly)

JAmanow
02-07-2011, 07:43 AM
Hello again.
In fact, I tried to pivot, but not sufficient, but after your påpackande exerted myself a little extra ching and I got what I wanted. It seems that sometimes you need to push forward.
Thanks for your help.