G
GDAVIS
I'm trying to duplicate an excel spreadsheet using a crosstab query in Access
2002. The data includes a Material Description and an ID. I would like to
have 2 column headings (one for the Description and one for the id). The
value is the same for both. I tried to concatenate the data together but the
user wants each on a different row.
Example: Material Description = DMT with id = 1008
Material: DMT
1008
Value: .67
How do I get 2 column headings?
Thanks!
2002. The data includes a Material Description and an ID. I would like to
have 2 column headings (one for the Description and one for the id). The
value is the same for both. I tried to concatenate the data together but the
user wants each on a different row.
Example: Material Description = DMT with id = 1008
Material: DMT
1008
Value: .67
How do I get 2 column headings?
Thanks!