On Thu, 21 Sep 2006 15:46:02 -0700, HL <HL[ at ]discussions.microsoft.com>
wrote:
[Quoted Text] >I have a large Excel spreadsheet imported to access and would like to get
>data from multiple rows but only show the colunm heading where the value that
>meets the criteria appear in the queary or report
So if you have 1000 rows, all with different contents, you want each
row to have different headers?
Access simply doesn't work that way. I would strongly suggest
normalizing your data; rather than a different FIELD for each value,
use a different RECORD. It sounds like you have a classic many to many
relationship between whatever is in the rows of your spreadsheet and
the values in the column headers. A two-field table with the row
identifier and the column heading as field values will let you
represent this information in a normalized table structure.
John W. Vinson[MVP]
|