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

Concatenated column in a report

P: n/a
Hello

I'm trying to concatenate fields in a report and display them. The fields
coming in from the query are like this:

A
B
C
D
E

I want to display

A
AB
ABC
ABCD
ABCDE

It seems to me the simplest way would be to concatenate the incoming field
to the existing value in a text box in the detail section of the report.
But Access wipes this field out every time so no accumulation occurs.
What's the best way to do this? Do I need to set up a temporary field in my
code?

Robert
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a

"Robert" <pr**********@yahoo.com> wrote in message
news:10*************@corp.supernews.com...
Hello

I'm trying to concatenate fields in a report and display them. The fields
coming in from the query are like this:

A
B
C
D
E

I want to display

A
AB
ABC
ABCD
ABCDE

It seems to me the simplest way would be to concatenate the incoming field
to the existing value in a text box in the detail section of the report.
But Access wipes this field out every time so no accumulation occurs.
What's the best way to do this? Do I need to set up a temporary field in my code?

Robert


I figured it out. Thanks.
Nov 12 '05 #2

P: n/a

Robert <pr**********@yahoo.com> wrote in message
news:10*************@corp.supernews.com...

"Robert" <pr**********@yahoo.com> wrote in message
news:10*************@corp.supernews.com...
Hello

I'm trying to concatenate fields in a report and display them. The fields
coming in from the query are like this:

A
B
C
D
E

I want to display

A
AB
ABC
ABCD
ABCDE

It seems to me the simplest way would be to concatenate the incoming field
to the existing value in a text box in the detail section of the report.
But Access wipes this field out every time so no accumulation occurs.
What's the best way to do this? Do I need to set up a temporary field in

my
code?

Robert


I figured it out. Thanks.

Hmmm - Thought the idea round here was to share information !!
DB

Nov 12 '05 #3

P: n/a

"David B" <Da***@marleycotenospam.fsnet.co.uk> wrote in message
news:c1**********@news7.svr.pol.co.uk...

Robert <pr**********@yahoo.com> wrote in message
news:10*************@corp.supernews.com...

"Robert" <pr**********@yahoo.com> wrote in message
news:10*************@corp.supernews.com...
Hello

I'm trying to concatenate fields in a report and display them. The fields coming in from the query are like this:

A
B
C
D
E

I want to display

A
AB
ABC
ABCD
ABCDE

It seems to me the simplest way would be to concatenate the incoming field to the existing value in a text box in the detail section of the report. But Access wipes this field out every time so no accumulation occurs.
What's the best way to do this? Do I need to set up a temporary field
in my
code?

Robert


I figured it out. Thanks.

Hmmm - Thought the idea round here was to share information !!
DB

I used code. No big deal. Just 2 lines, 1 to initialize the textbox at the
beginning of the group and 1 to move in the new values.
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.