Report for updated cross tab query in ms access 2007

[ariful alam]

Hello,
I have cross tab query that shows the last closing balance of Inventories stored in various stores. Now i have 5 stores those store inventories. But stores may add later depending on quantity of inventories.

Now, i like to create a report that will show the cross tab query data. but the problem is when i create a report for that cross tab query it adds the stores as column those exists in query. but how can i add the future stores those will add in future.

Thanks

[Rabbit]

Unless you want to get into heavy vba, just add those columns as new stores are added.

[ariful alam]

But i don't like to add VBA in my application. I m going to do alternative way using EXCEL. lets see, what happens...