D
David Mueller
My goal is to denormalize my table. So, I'm looking to append a "sequence"
number to the field names in my table.
For example, MyDate and MyAmount fields would become MyDate1, MyAmount1,
MyDate2, MyAmount2, ... and so on for each unique customer.
I added a new field called MySequence, which is populated with the 1, 2, ...
number accordingly.
Now, I just can't seem to write a crosstab query or use a pivot view to
create a new table, or export to excel.
Using the query builder Pivot View "wizard", I can drag-n-drop fields and
create my desired output on the screen, but I can't make use of it because it
truly seems to be just a "view". Export to Excel would help, but that
insists on giving me counts, not my actual data, which I see on the screen.
Good grief, I can't even describe this very well.
Is it possible to write this query?
Thanks so much,
David
number to the field names in my table.
For example, MyDate and MyAmount fields would become MyDate1, MyAmount1,
MyDate2, MyAmount2, ... and so on for each unique customer.
I added a new field called MySequence, which is populated with the 1, 2, ...
number accordingly.
Now, I just can't seem to write a crosstab query or use a pivot view to
create a new table, or export to excel.
Using the query builder Pivot View "wizard", I can drag-n-drop fields and
create my desired output on the screen, but I can't make use of it because it
truly seems to be just a "view". Export to Excel would help, but that
insists on giving me counts, not my actual data, which I see on the screen.
Good grief, I can't even describe this very well.
Is it possible to write this query?
Thanks so much,
David