98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Can a report has more than one record source | Access forum
Can a report has more than one record source | Access forum
Resolved · Low Priority · Version 2003
Wed 1 Dec 2010, 15:40Delegate Betty said...
Betty has attended:
Access Intermediate course
Access Advanced course
Can a report has more than one record source
When creating a report, can we have more than one record source, i.e. in one report, we draws the data from different types of queries ran? or the report has to be linked to a specific query
Thu 2 Dec 2010, 12:32Trainer Stephen said...
RE: Can a report has more than one record source
Hi Betty
Thanks for your question
A report must have one unique recordsource, be it a table or query.
However it is possible to use sub reports/forms to view data on multiple related tables. this is covered on the advanced course
Regards
Stephen
Thu 9 Dec 2010: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Space marksIt is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names |
