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

For Each Loop

P: 1
I have created an MS Access Database and need help creating some reports. The database stores client information and billing information. I have designed queries that pull certain fields, however I am looking to create reports for each record in the query. I know this is possible but have been having alot of trouble forumlating the code. Any help would be appreciated.
Apr 25 '12 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 15k+
P: 31,492
Well, for such a large and non-specific question, there is little I can do for you in the way of detail. I would only say that you may need to consider opening the report within each iteration of the loop and filtering each open to match the individual record for the iteration.

Good luck.
Apr 25 '12 #2

P: 759
I don't know exactly what key must be pushed but, from the top of my had, I can say that you can insert, in the report, a page break before (or after) each record.
Let me know if that help you. If not, I'll try in a future post, to be more specific.
Apr 26 '12 #3

Post your reply

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