the tables what you created are the tables which is used to generate following op

ENTERPRISE

DESCRIPTION count amt count amt count amt count amt

A 1 2000 1 4000 2 3000 2 7000

B 0 0 0 0 0 0 0 0

c 0 0 0 0 0 0 0 0

D 1 7000 0 0 2 13000 0 0

E 0 0 0 0 0 0 0 0

F 0 0 0 0 0 0 0 0

G 0 0 0 0 0 0 0 0

H 0 0 0 0 0 0 0 0

I 0 0 0 0 0 0 0 0

op is based on the year and month only (for example user provide 201303 in selection criteria)

Hope this is clear to you. pls help me to generate the query

thanks

nick