Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

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

ResolvedVersion Standard

Wed 29 Nov 2006, 16:56 Delegate 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

Fri 1 Dec 2006, 09:44 Trainer 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:

Hiding rows and columns

To hide a column or row in Access, you need to minimise the column or row. This can be done by placing your mouse on the right edge of a column, wait for the mouse to change to a double aroow and then drag to minimise the column

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

microsoft access training courses - Queries and reports

Queries and reports

RE: queries and reports

Access articles

Access tip:

Hiding rows and columns