T
Tim
This is a response to my own 7/17 string of posts and
replies.
My problem was trying to take a normalized table of 20
records per ID and transpoe it to a flat-file format.
Suggestions given to me were cross-tabbing (too many
fields) and advanced non-Access SQL.
The solution was easier than it should have been:
1. Create the transpose query, such that it is the 80
variables across, and still 20 rows per ID, but yielding a
null if not the correct row-variable
2. Create a 2nd query, aggregated, taking the min of each
of the 80+ variables.
Much easier than any other suggestion from here or
otherwise, and it definitely works. Thought you all might
want to know!
replies.
My problem was trying to take a normalized table of 20
records per ID and transpoe it to a flat-file format.
Suggestions given to me were cross-tabbing (too many
fields) and advanced non-Access SQL.
The solution was easier than it should have been:
1. Create the transpose query, such that it is the 80
variables across, and still 20 rows per ID, but yielding a
null if not the correct row-variable
2. Create a 2nd query, aggregated, taking the min of each
of the 80+ variables.
Much easier than any other suggestion from here or
otherwise, and it definitely works. Thought you all might
want to know!