microsoft training access course - 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