Queries

The UK's most regular instructor-led training courses.
Training information: access courses in london · Microsoft access courses · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Queries

Otis has attended:
Access Intermediate course
Access Advanced course

by - delegate Otis [1 post] (2008 Mar 11 Tue, 16:59) Reply

how to crosstab

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 2 Tue	Southwark	3	book now	£210	£215
2003	2008 Sep 9 Tue	Bloomsbury	6	book now	£193	£215
2002/XP	2008 Sep 11 Thu	Tooting	0	FULL
2003	2008 Sep 19 Fri	Bayswater	5	book now	£195	£205
2007	2008 Sep 23 Tue	Bloomsbury	5	book now	£212	£224
2002/XP	2008 Sep 24 Wed	Tooting	0	FULL
Full Schedule: See all 73 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: queries

by - trainer Pete platinum contributer [799 posts] (2008 Mar 25 Tue, 10:07) Reply

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.

· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course
· Microsoft Access Tighten your Security Controls
· Access VBA Handling Errors and Debugging Code
· Microsoft Access 2007: New Features
· Material covered on a Microsoft Access Course

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