M
MichelleNH
I have a database that tracks our warehouse inventory. I have created a pie
chart based on three fields. !) TransactionDate, which through nested
queries returns the date of the last transaction dealing with an item. 2)
PropertyNumber, which is a unique number given to a particular item we have
in inventory. 3) InvCost, which is an expression that muliples our inventory
level by the current cost of an item.
The pie chart summarizes InvCost, and the slices represent the year the item
last had a transaction. This pie has many slices, (a slice from every year
from 1988 to 2006) and I would like to group them. For example, I'd like to
have 1 slice for years 1996 and before, 1997-2001, 2002 - 2004, 2005, and
2006. Is there anyway to do that? Do I have to create another query?
chart based on three fields. !) TransactionDate, which through nested
queries returns the date of the last transaction dealing with an item. 2)
PropertyNumber, which is a unique number given to a particular item we have
in inventory. 3) InvCost, which is an expression that muliples our inventory
level by the current cost of an item.
The pie chart summarizes InvCost, and the slices represent the year the item
last had a transaction. This pie has many slices, (a slice from every year
from 1988 to 2006) and I would like to group them. For example, I'd like to
have 1 slice for years 1996 and before, 1997-2001, 2002 - 2004, 2005, and
2006. Is there anyway to do that? Do I have to create another query?