microsoft training access course - access


starstarstarstarstar Excellent

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft training access course - Access

microsoft training access course - Access

resolvedResolved · Low Priority · Version Standard

Thu 26 Apr 2007, 12:02 replyReply Delegate Yasmin said...

Yasmin has attended:
Access Introduction course
Access Intermediate course


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.

For upcoming training course dates see: Pricing & availability

Thu 26 Apr 2007, 13:03 replyReply Trainer David said...

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