Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Queries

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Queries

Resolved · Low Priority · Version Standard

Reply 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

Reply 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.

Access articles

· Microsoft Access Training Unleashes the Power of the Pivot Table
· How To Use A Parameter Query In Access
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· Getting To The Nitty-gritty Via Microsoft Access
· How much time could you save with Access?

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