access table field value to field name

[jpaeze]

Hi all
newbie here so go easy on me
i need to extract data from MSaccess 2000 tables as follows
but i do not know how to set it up

my existing table has these 3 fields and 4 records

PartNumber PropertyName PropertyValue
1 TYPE connector
1 PACKAGE conn10
2 TYPE ic
2 PACKAGE plcc44

what i need to achieve is for field values Type and PACKAGE to become the field headings , so that i have a new table with only one record per partnumber with the correspOnding propertyvalues under each field/propertyname

PartNumber TYPE PACKAGE
1 connector conn10
2 ic plcc44

can this be achieved within access queries or do i need to do some programming to achive it?
any help would be greatly appreciated

 

[KenReay]

Hi

Not sure I understand you completely, looks to me like you need a cross table query

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK