I make a crosstab query the items in the raw header and months in column header, quantity is the value.
I set column for maximum qty of months.
the problem appear if one item duplicated in one month, access take the maximum of individual value not for the summation of every month.
I set column for maximum qty of months.
the problem appear if one item duplicated in one month, access take the maximum of individual value not for the summation of every month.