S
Sonya
I hope I dont confuse you too much, but my report consists of clothing items
issued. I have a query that calculates each item issued (Issued:
QtyAllocated) ie: my clothing item description is: blue jeans 30 x 30 = 5;
blue jeans 30 x 32 = 2; white shirt = 5; blue shirt = 6; etc. I have added
an Item Desc field such as Blue Jeans on all the Jeans and Shirts on all the
shirts as I would like to creat a report that tells me Blue Jeans = 7; Shirts
= 11. And I kind of got what I want by putting =Sum([Issued]) as the
calculation on the Issued Footer, but it shows a line for each item issued
such as the blue jeans are listed like:
Blue Jeans
5
7
Shirts
5
11
and so on. How do I get me report to read?
Blue Jeans
7
Shirts
11
Thanks in advance for any help on this matter.
issued. I have a query that calculates each item issued (Issued:
QtyAllocated) ie: my clothing item description is: blue jeans 30 x 30 = 5;
blue jeans 30 x 32 = 2; white shirt = 5; blue shirt = 6; etc. I have added
an Item Desc field such as Blue Jeans on all the Jeans and Shirts on all the
shirts as I would like to creat a report that tells me Blue Jeans = 7; Shirts
= 11. And I kind of got what I want by putting =Sum([Issued]) as the
calculation on the Issued Footer, but it shows a line for each item issued
such as the blue jeans are listed like:
Blue Jeans
5
7
Shirts
5
11
and so on. How do I get me report to read?
Blue Jeans
7
Shirts
11
Thanks in advance for any help on this matter.