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 » Crosstab query

	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:

Crosstab query

Resolved · Low Priority · Version 2003

ReplyMon 22 Feb 2010, 15:51Delegate Phylicia said...

Crosstab query

What would be the method of condensing over 65,000 records with repeating data using a cross tab query

For upcoming training course dates see: Pricing & availability

ReplyTue 23 Feb 2010, 11:06Trainer Stephen said...

RE: Crosstab query

Hi Phylicia

Thanks for your question

Generally speaking a crostab query will group records based upon the row and column fields specified. There is no real limit to the number of records that it can process.

Could you perhaps clarify your question with a specific example

Thanks

Stephen

Access articles

· Supersizing your databases via Microsoft Access
· Create A Simple Form In Access
· Insert A Real-Time Clock In An Access Form
· Bring Access Up To Speed
· Interested In The Golden Rules For Building Access Databases?

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

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips

Costs Are Easier To Control With MS Project

No organisation, large or small, can ever afford to let spending on a project spiral out of control. However, it's not always easy to keep costs in hand, particularly if you don't have the best tools to manage expenditure. To this end, why not see what Microsoft Project 2010 and its range of cost-control tools can do for you?

» Article: Microsoft+project+training+london

Can you custom sort multiple tabs at the same time. If you group tabs it wont let you enter the custom sort parameters, is there anyother way of doing it?

» Forum post: Custom Sort Multiple Tabs

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. U...