Output of a crosstab into a Memo field

[Phil Latio]

My quandary is this.....

I have a label application (Bartender) that I have hooked up to Access,
to use the output of a cross tab.

I've succeeded in getting the data within Access, but my problem lies
with my getting the output of the crosstab into one field in the label
template.

Basically, my crosstab of cloth sizes and quantities, which could be in
size buckets of varying definitions eg;

S, M, L, XL or
8, 10, 12, 14 or
2-3, 3-4, 4-5 etc etc

The label application only recognises individual fields of the
datasource and doesn't have the functionality to act like a report/sub
report (which is ideally what I really want!).
The number of fields may not be consistent each time it's run!

I'm thinking I ought to loop through the querydef to get the field
names, then loop through a recordset and build a string of the entire
query output, and dump it into a Memo field.

Has anyone had to do anything like this before, or offer up suggestions
for better way...?

Thanks in advance.

Cheers

Phil

[Keith Wilby]

"Phil Latio" <ph********@lycos.co.ukwrote in message
news:11**********************@e3g2000cwe.googlegro ups.com...

My quandary is this.....

I have a label application (Bartender) that I have hooked up to Access,
to use the output of a cross tab.

I've succeeded in getting the data within Access, but my problem lies
with my getting the output of the crosstab into one field in the label
template.

Basically, my crosstab of cloth sizes and quantities, which could be in
size buckets of varying definitions eg;

S, M, L, XL or
8, 10, 12, 14 or
2-3, 3-4, 4-5 etc etc

The label application only recognises individual fields of the
datasource and doesn't have the functionality to act like a report/sub
report (which is ideally what I really want!).
The number of fields may not be consistent each time it's run!

I'm thinking I ought to loop through the querydef to get the field
names, then loop through a recordset and build a string of the entire
query output, and dump it into a Memo field.

Has anyone had to do anything like this before, or offer up suggestions
for better way...?

Thanks in advance.

Cheers

Phil

I don't think there's anything wrong with what you're proposing except for
the "dump it into a Memo field" bit. Just concatenate at run-time using a
query. <pun alert Hope you get it licked.

Regards,
Keith.

[Phil Latio]

Just re-read my post and I missed something out which may be relevant;

My Xtab query may have several rows along the lines of;

Style Colour S M L XL XXL
ABC RED 1 2 2 1 1
ABC BLUE 1 2 2 1 1
ABC GRN 1 1 2 2 1

I'm looking to re-build that in it'sentirety as a string!!
I'm thinking it's going to be awfully nasty with a liberal sprinkling
of vbTab's and vbCrLf's dotted around

:-(
Keith Wilby wrote:

"Phil Latio" <ph********@lycos.co.ukwrote in message
news:11**********************@e3g2000cwe.googlegro ups.com...

My quandary is this.....

I have a label application (Bartender) that I have hooked up to Access,
to use the output of a cross tab.

I've succeeded in getting the data within Access, but my problem lies
with my getting the output of the crosstab into one field in the label
template.

Basically, my crosstab of cloth sizes and quantities, which could be in
size buckets of varying definitions eg;

S, M, L, XL or
8, 10, 12, 14 or
2-3, 3-4, 4-5 etc etc

The label application only recognises individual fields of the
datasource and doesn't have the functionality to act like a report/sub
report (which is ideally what I really want!).
The number of fields may not be consistent each time it's run!

I'm thinking I ought to loop through the querydef to get the field
names, then loop through a recordset and build a string of the entire
query output, and dump it into a Memo field.

Has anyone had to do anything like this before, or offer up suggestions
for better way...?

Thanks in advance.

Cheers

Phil

I don't think there's anything wrong with what you're proposing except for
the "dump it into a Memo field" bit. Just concatenate at run-time using a
query. <pun alert Hope you get it licked.

Regards,
Keith.