microsoft access training courses - queries and reports
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training courses - Queries and reports

microsoft access training courses - Queries and reports

resolvedResolved · Low Priority · Version Standard

replyReply Wed 29 Nov 2006, 16:56Delegate Dylan said...

Dylan has attended:
Access VBA course

Queries and reports

I am creating a report but need 'values' that have been returned from more than one query (4 in fact). When I try and create a query from the 4 different queries and use this for my report it doesn't work? Any help would be welcomed. Many thanks

For upcoming training course dates see: Pricing & availability

replyReply Fri 1 Dec 2006, 09:44Trainer Orok said...

RE: queries and reports

Hi Dylan,

I would suggest collecting the results of the 4 queries together using a combination of first a Maketable and then Append Queries.

Once the query results are gathered together in a table, then a report can be created based on this new table.

Regards


 

Access tip:

Combo box for finding records

You can use a combo box in a form to look up a record. If you place the comb box in the Form header, by then selcting they a field type from the drop down loist, you will see the record for it

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard