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 » Pivot table

	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:

Pivot table

Resolved · High Priority · Version 2007

ReplyMon 8 Jun 2009, 17:01Delegate Daljit said...

Pivot table

how do i create a pivot table with 2/3 rows and multiple columns

For upcoming training course dates see: Pricing & availability

ReplyTue 9 Jun 2009, 07:29Trainer Rajeev said...

RE: pivot table

Dear Daljit

I believe that you have asked this question twice. I have already answered your previous query and hopefully you would have found it useful!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Mon 15 Jun 2009: Automatically marked as resolved.

Access articles

· So You Want To Create Forms In Access 2007?
· Get To Know The 3 As: Access Accuracy Achievement
· Supersizing your databases via Microsoft Access
· Reasons to Consider Microsoft Access Training
· Some Things You May Not Know About Relational Databases

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

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.

View all Access hints and tips

Why Proper Checking Systems Are A Good Thing For Performance Quality

Even the best employee however, will make mistakes every now and again. These days when technology helps us in every aspect of our lives, it is worth bearing in mind that technology was designed and built by humans and is therefore just as fallible as we are. What can you do to reduce these errors or at least catch them when they happen to improve the quality of performance?

» Article: Improving performance management

Hi,

I have a spreadsheet with costs for different stationery types (paper etc.) from different stationery firms I want to show in the last column the name of the company which has the cheapest number for each item

For example if Staples paper was ch..

» Forum post: Excel

The DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip:

In a blank worksheet, type the birth date in cell A1, using slashes to sep...