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

How to Display a Record Twice in a Report

P: 27
I have a record of deliverables that has an Issue Date and a Review Date that might be a few weeks apart. The client wants 1 report that shows review date and issue dates mixed together and sorted by date, so if the record has both dates it would show up once with the review date and a second time with the issue date. I don't know how to do that without creating some kind of temporary table with two records for each record that has both dates. If I create this table I dont know how to do it just before they print the report. Any suggestions?

He doesn't want two reports or a list of issue dates and then review dates he wants them all mixed together by date
Mar 27 '10 #1
Share this Question
Share on Google+
1 Reply

Expert 5K+
P: 8,704
As you have already indicated, you can programmatically create a Temporary Table satisfying your criteria, then on the Open() Event of the Report, assign the Record Source to this Table.
Mar 27 '10 #2

Post your reply

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