Hi Volks, Try using the crosstab query wizard. Select the Query tab on the database window, select new, select Crosstab Query Wizard. This will walk you through the process.
Glenn P. Jones -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of v_f_dauber Sent: Wednesday, 15 June, 2005 12:58 PM To: [email protected] Subject: [AccessDevelopers] pivot table Hi, I need to create a table that has ten different items in rows and say a time frame of ten years in the colums. i want that every time the user selects a new project this ten by ten matrix is created. is there an easy way of doing this? or is it better to just use excel spreadsheets and import the data? i was hoping for something like a main form that has then projects and then a subform or a new form started by the main form that would display then ten by ten matrix. e.g. project 1 year 1 year 2 year 3 .... item a item b item c ... any help greatly appreciated. cheers volks Please zip all files prior to uploading to Files section. Yahoo! Groups Links Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
