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 » Queries

Queries

resolvedResolved · Low Priority · Version Standard

replyReply Tue 11 Mar 2008, 16:59Delegate Otis said...

Otis has attended:
Access Intermediate course
Access Advanced course

Queries

how to crosstab

For upcoming training course dates see: Pricing & availability

replyReply Tue 25 Mar 2008, 10:07Trainer Pete said...

RE: queries

Hi Otis, Thank you for the post, welcome to the forum, in answer to your question, creating a crosstab query which is a summarisation of your data, the easiest and most straightforward way to do this is to follow the Crosstab query wizard which you can invoke by going to the Queries objects click on New and select Crosstab query wizard, follow the steps to create your query. I look forward to seeing you on the forum in future, best regards Pete.

 

Please browse our web site to find out more about
access courses in london and other Microsoft training courses.

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub


3. Open your form in Form View and use the TAB key to make sure it works.

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