cross-tab question

[sat6845]

Hi.

I need to put this information in the cross tab.

After calulating here is the data looks in the detail.

ITEM|Received Date - Approved in week - Despatch within week
xx 1/1/2005 2 4
x1 1/2/2005 1 1

Approved in week:
Datediff("W" Received_date,Approved in week)
despatch("w" Received_date,Despatch in week)

The requirement is get the count for the week1 how many got dispatch once the order got received and approved with 1 week or 2 week or 3 week. I need count for...

I need to get the cross tab like this.

WEEK 1 - Week 2 - Week 3 - Week 4
Aproved 2 1 1 1
despatcvh 1 2 1 2


Is this possibbe in cross-tab.

Thank you.

sat

 

[Madawc]

Have you tried the cross-tab? Best to try and then ask for help if it doesn't work.

Madawc Williams (East Anglia, UK)