There is probably a simple answer to this, but I can't find it right now.
I have a cross tab query that takes the quantity of windows installed and tabulates them into quantities produced by week. The problem is that on Monday morning the first week column (20-32 in example) shos the total for the previous week rather than this week (20-33) with zero as the total. Once the first window is produced then everthign clicks into place.
The problem is that this produces live production data for another section and they want to see zero for the week if zero have been produced.
Thanks
I have a cross tab query that takes the quantity of windows installed and tabulates them into quantities produced by week. The problem is that on Monday morning the first week column (20-32 in example) shos the total for the previous week rather than this week (20-33) with zero as the total. Once the first window is produced then everthign clicks into place.
The problem is that this produces live production data for another section and they want to see zero for the week if zero have been produced.
Thanks