Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

cross tabs

ResolvedVersion 2003

Suad has attended:
Access Intermediate course

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.

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

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 tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.