This is a bit of a continuation of this post, but I'm referring to a different procedure and I didn't want this to get lost in the shuffle...
Using Norie's code I got a "Wide" table into a "Flat" format to follow the rules of normalization. I've run my query on my flat table, but the results are also "Flat"... and I need them back to the Wide format...
The resulting query fields are arranged as follows:
Directory, Demographic, Value
with Directory being a 6 digit number, Demographic being the name of the demographic being measured (e.g. population, number of households, etc.), and Value being that measurement.
So, what I'm looking to do is have Directory remain in Field 1, but have the various Demographics be the field headers going out to the right ("Wide"), and the values in the appropriate cells. For example:
Directory, Population, Households, Distribution
123456 , 150000 , 80000 , 90000
456789 , 100000 , 75000 , 80000
Any thoughts on how to get there?
Using Norie's code I got a "Wide" table into a "Flat" format to follow the rules of normalization. I've run my query on my flat table, but the results are also "Flat"... and I need them back to the Wide format...
The resulting query fields are arranged as follows:
Directory, Demographic, Value
with Directory being a 6 digit number, Demographic being the name of the demographic being measured (e.g. population, number of households, etc.), and Value being that measurement.
So, what I'm looking to do is have Directory remain in Field 1, but have the various Demographics be the field headers going out to the right ("Wide"), and the values in the appropriate cells. For example:
Directory, Population, Households, Distribution
123456 , 150000 , 80000 , 90000
456789 , 100000 , 75000 , 80000
Any thoughts on how to get there?