By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,940 Members | 611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,940 IT Pros & Developers. It's quick & easy.

Report for updated cross tab query in ms access 2007

ariful alam
P: 185
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.

Jun 22 '12 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 10K+
P: 12,357
Unless you want to get into heavy vba, just add those columns as new stores are added.
Jun 22 '12 #2

ariful alam
P: 185
But i don't like to add VBA in my application. I m going to do alternative way using EXCEL. lets see, what happens...
Jun 22 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.