98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » microsoft training access course - Access
microsoft training access course - Access
Resolved · Low Priority · Version Standard
Yasmin has attended:
Access Introduction course
Access Intermediate course
Access
I have two similar queries reporting different sets of data.
I want to present or display the results on one report. Please advise how I can do this.
RE: Access
Hi Yasmin
I hope you are enjoying access now that you have completed two of our three Microsoft Access courses.
There are two methods to solve your problem. The first is to create a new query that contains all of the fields from the original queries. The second option is when you create your report, you can bring data into it from both the queries.
The best way of achieving this, is to create the report in design view, that way you can place the data items where you want them to appear, then this will repeat for each row.
Hope this helps
David
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:Convert A Form Into A ReportIf there is a form that you want to to save as a report: |