The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Cross tabs

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

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

Training information:

Cross tabs

Resolved · Low Priority · Version 2003

ReplyFri 13 Nov 2009, 13:00Delegate Suad said...

Cross tabs

Hello,

I've tried creating a cross tab table but can't remember how to get the total of the value i've managed to count.

For upcoming training course dates see: Pricing & availability

ReplyTue 17 Nov 2009, 09:20Trainer Stephen said...

RE: Cross tabs

Hi Suad

Thanks for your question

I have reviewed your question , and passed it to a colleague for his attention

We will reply shortly

Regards

Stephen

ReplyMon 23 Nov 2009, 22:51Trainer Simon said...

RE: Cross tabs

Hi Suad,

Thank you for your question and sorry about the delay in responding.

Create a new crosstab query and choose your row and column headings. After selecting the data field from the right hand box choose the Sum function.

If you have already created your crosstab, then go to Design view of the query and change the Count function to Sum in the Total Row.

I hope this answers your question.

Regards

Simon

Mon 30 Nov 2009: Automatically marked as resolved.

Access articles

· Getting to grips with Access 2007's Opening Screen and User Interface
· A Brief Guide To Table Relationships In Access
· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course
· Find Out About The Join Property In An Access Query
· How To Make Access 2010 Databases Compatible With Access 2007

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

Access tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips

If moving tasks between groups will dependencies be tailored accordingly