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



Training courses
London & UK

Live dates & prices

On-site training

Get a quote


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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.