By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,525 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

Output of a crosstab into a Memo field

P: n/a
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

Nov 21 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"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.
Nov 21 '06 #2

P: n/a
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.
Nov 21 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.