473,322 Members | 1,778 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Concatenated column in a report

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
3 1816

"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

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

"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Mike Conklin | last post by:
This one really has me going. Probably something silly. I'm using dcount for a report to determine the number of different types of tests proctored in a semester. My report is based on a...
0
by: Greg Reed | last post by:
I have a 4 column report and wondered if there is column number property. I have more complicated uses for it but basically could I Have column number shown at ctop of each column 1 ...
0
by: Nunya Biznas | last post by:
I have a two column report that needs to have the word "continued" appear at the top of the 2nd column if the detail records are part of the group from the previous column. I have tried using a...
5
by: Alpha | last post by:
Is there any way to create a new column in a dataset table from 2 string column and a int column? I got an error "expecting string" from my code below. Any help would be appreciated. ...
1
by: Markw | last post by:
Hi folks, I probably used the term 'report' incorrectly. Sorry for that in advance. The below code produces a 2 column web page that shows in the first column a picture and the 2nd column shows...
2
by: TSGB | last post by:
Hi all, I need to make a report and to save space I need to be able to display the title(label) in a column report just once per page. Ex. Result from record 1 Result from...
1
by: mskapek | last post by:
I need some advise on how to best create an Access 2002 report from multiple "total" queries, each which result in 3- 5 values that I need displayed on my report. Most of the queries do simple...
2
by: aamirvip | last post by:
hi, i want to align a concatenated column. for example: i've 3 columns named a, b c select a + b + c i want to show these 3 columns in right aligned form.
6
by: gingernob | last post by:
I have a report with 18 columns. The intention is to print out a seating plan of a class room. the max seats / row is 18 BUT sometimes it is less. the query for data provides me with 3 columns of...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.