Sammentælle felter fra 3 krydstabuleringer

didnt this work http://www.eksperten.dk/spm/916682 ?

Kan du ikke blot lave en forespørgsel og vise totaler med en gruppering på lønnummer og antal?

Hi Terry


Yes worked in tabel with one columm.

Now I have to count the number of dates, in 3 differnent columms.

Every time af date acour, it has to look on the person-id, and count how many times, he shows up.

I have made 3 Krydstabulerings forespørgsel (onr for each columm, each working fine but now I have to, gather them into one ?

I cannot make it work in a normal Qeury or in "krydstabulering".

Regards

Tony

Obviously not having a full understanding of your data or exactly what your trying to do doesnt help.


Why do you have three cross-tab queries, do you also have three tables?


Can you try explaining in more detail so I get a better picture?

Hi Terry

I have 2 tables.

1 Lønnummer: medarberjderID, lonnummer, fornavn, efternavn

2 Medarbejder: ID, bemærkning, Medarbejderid1, Medarbejderid2, Medarbejderid3, Dato, Oprettet af, Oprettet tid.

I have to count how many times each employee, figures in
Medarbejderid1, Medarbejderid2, Medarbejderid3.

I have made 3 cross-tab queries, each counting how many in each
colomm, so now i have to get the total for each employee.

Regards

Tony

how are the tables related and why 3 medarb.ids in same record?

Hi Terry


The reason of 3 "medarbejder" in the same record, is because
they work together up to 3 persons at the time, so this report system is keepping track, if one employee make many big mistakes.

Tables are related from lonnummer.medarbejderID to Medarbejder.medarbejderid and Medarbejder.medarbejderid1 and Medarbejder.medarbejderid2


Regards

Tony

so all employees are in the first table and these can be found a number of times in table 2 in either of the columnd?

I see 4 columdn inb the second table with medarb.ID???

Any chance of seeing an example of these tables?

If I understand your data correctly you can make three sub selects each of which selects count where emp.id in the first table is = empid in the second table (col1, col2 or col3)

Hi Terry


If you have time I can mail it to you.


I have your email.


Regards

Tony

ekspertenATsanthell.dk

AT = @

svar