The first step is to normalize your "I have a table". If you can't do this,
use a union query to create a normalized recordset:
SELECT Book as Qty, "Book" As Item, DateSerial(Cyear, Month, 1) as TheDate
FROM [I have a table]
UNION
SELECT Pen, "Pen", DateSerial(Cyear, Month, 1)
FROM [I have a table]
UNION
SELECT Bag, "Bag", DateSerial(Cyear, Month, 1)
FROM [I have a table];
You can then create a crosstab query with Item as the Row Heading,
Format(TheDate,"mmmyy") as the Column Heading, Sum(Qty) as the Value.
To get the jan-feb totals you can add row headings like:
JanFeb2004: Abs(Year(TheDate=2004)) * Qty
Sum

Signature
Duane Hookom
MS Access MVP
--
> Hi All:
> I have a table with integer data as follows:
[quoted text clipped - 10 lines]
>
> --Thanks in advance