How to analyze data and output it in table form?

=?Utf-8?B?TGl0dGxlIEJlZ2lubmVy?=

Guest

Posts: n/a

31st Oct 2007

I am a beginner in MS Access and would like to try some data analysis.

I have a database like this:
http://hk.geocities.com/butterflycharles/access.jpg

And I would like to analyze the data and output a table like this:
http://hk.geocities.com/butterflycha...micprofile.jpg

Please let me know what I should use(e.g. query, functions, reports, etc.).
If possible, please let me know the corresponding tutorials so that I can
understand what's going on. I wonder if crosstab query is the answer. Thank
you!!!

« Count how many spaces | Macro to check data from excel list against access query and return value back to excel »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Requery, Output to table, Add Display in Form	=?Utf-8?B?bmV0YWRtaW4=?=	Microsoft Access	3	25th Feb 2007 05:22 PM
Analyze with word- one page output?	Pamela	Microsoft Access Reports	0	22nd Nov 2005 07:47 PM
Re: Compile/Analyze Word Form Field data from multiple forms?	Dave Peterson	Microsoft Word Document Management	2	14th Jul 2005 02:54 AM
Compile/Analyze Word Form Field data from multiple forms?	=?Utf-8?B?amd1bmRlbA==?=	Microsoft Excel Misc	3	14th Jul 2005 02:54 AM
Output data from multiple records in a table	=?Utf-8?B?RGF2ZQ==?=	Microsoft Access VBA Modules	2	7th Jul 2005 10:21 PM