access-training-courses - queries
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 » access-training-courses - Queries

access-training-courses - Queries

resolvedResolved · Low Priority · Version Standard

replyReply Thu 25 Oct 2007, 16:54Delegate Sabine said...

Sabine has attended:
Access Intermediate course

Queries

how do i link my query to my table and then to my report?

For upcoming training course dates see: Pricing & availability

replyReply Sun 28 Oct 2007, 00:40Trainer Rajeev said...

RE: queries

Dear Sabine

Not sure exactly what you are seeking!! I hope you are aware that when you create a report using the wizard you can choose any table or query.

I am not sure what you mean by linking!! When you create a query from a table they are automatically linked.

Did you mean if you change the table how it is reflected in the existing report/s?


 

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

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