J
Juls
Hi,
This a repost of a question I didn't explain properly.
I've changed the example to show this, sorry,
Call time
Ref Dte Centre QNo ACW ACD
13816911 38169 1 1 1.1 1.2
13816912 38169 1 2 2.1 2.2
13816913 38169 1 3 3.1 3.2
23816921 38169 2 1 1.4 7
13820011 38200 1 1 1 10
13820013 38200 1 3 3 13
Queues
Ref Centre QNo QName ShNme
11 1 1 Motor NB MNB
12 1 2 Packages NB PNB
13 1 3 SBC NB CNB
What I want is-
Queues.Qno Queues.ShNme Calltime.acw Calltime.acd
1 MNB 1.1 1.2
2 PNB 2.1 2.2
3 CNB 3.1 3.2
When Calltime.date <=38169 and centre = 1 or
Queues.Qno Queues.ShNme Calltime.acw Calltime.acd
1 MNB 1 10
2 PNB 2.1 2.2
3 CNB 3 13
When Calltime.date <=38200 and centre = 1 (the Calltime.date is the
date code from excell)
I'll need an each of the calltime.qno, dte is a the excel date code,
abd each QNo will not have an entry for each date but newest before a
set date will be required.
Sorry I didn't explain it properly.
Thanks for the help.
Juls
This a repost of a question I didn't explain properly.
I've changed the example to show this, sorry,
Call time
Ref Dte Centre QNo ACW ACD
13816911 38169 1 1 1.1 1.2
13816912 38169 1 2 2.1 2.2
13816913 38169 1 3 3.1 3.2
23816921 38169 2 1 1.4 7
13820011 38200 1 1 1 10
13820013 38200 1 3 3 13
Queues
Ref Centre QNo QName ShNme
11 1 1 Motor NB MNB
12 1 2 Packages NB PNB
13 1 3 SBC NB CNB
What I want is-
Queues.Qno Queues.ShNme Calltime.acw Calltime.acd
1 MNB 1.1 1.2
2 PNB 2.1 2.2
3 CNB 3.1 3.2
When Calltime.date <=38169 and centre = 1 or
Queues.Qno Queues.ShNme Calltime.acw Calltime.acd
1 MNB 1 10
2 PNB 2.1 2.2
3 CNB 3 13
When Calltime.date <=38200 and centre = 1 (the Calltime.date is the
date code from excell)
I'll need an each of the calltime.qno, dte is a the excel date code,
abd each QNo will not have an entry for each date but newest before a
set date will be required.
Sorry I didn't explain it properly.
Thanks for the help.
Juls