working with normalized data set

  • Thread starter Thread starter PF
  • Start date Start date
P

PF

Hi all,

I follow the guide and normalize a big data set containing transaction for
in/out of inventory part.

Instead of doing my first tough

tblDat:
=====
partNo
type
Inqt1
outqt1
Inqt2
outqt2
inqt3
outqt3
Inqt4
outqt4
.... and so up to
inqt12
outqt12

Where i have qty for in and out for each month

i follow this simple structure

tbldat:
=====
partNo char 7
type char 1 ('1'=in, '2'=out)
qt double
month integer

Now i have to do a select query that will display the data in columns as

partNo, In1,out1,in2,out2,in3,out3.....in12,out12

I need to see the data display in 24 colums, 2 colums for each month.

I do not want to use a crosstab query since i have other calculated colums
to add later
I just want to be able to build the colums.

is it possible to do and is it the correct data structure to be able to
display data
in 24 columns?

I tough the display of data is independant of data structure but now i am
wondering
if they are related.

Best regards,

Pierre
 
Hi,


TRANSFORM LAST(qt)
SELECT partNo
FROM myTable
GROUP BY parNo
PIVOT type & [Month]



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top