Back with a more challenging query

[satswid]

I have a table in the following manner

Class| Student Name| Address_Eng| Address_Por| Percentage| Subject| Marks
1 st1 Tinsel Town Trerfmd 100
1 st1 XYZ Street XYZ Aerd 100
1 st1 Bldg ABCD Blefdg ABCD 100
1 st1 ---------- ------------ 100
2 st2 China Town China Retedaw 75


I have created a classwise report.

Class: xyz
School: abc

Student Roll No | Name | Subject | Marks
st1 Student1 Maths 79
st1 Student1 Science 99
st1 Student1 History 99
st2 Student2 Maths 87
etc
***
***

In the same report, I want a field in which Addresses are displayed in one field(mixture of both languages), studentwise

Like:

Tinsel Town
XYZ Street
Bldg ABCD
-------------
Trerfmd
XYZ Aerd
Blefdg ABCD


Please help!!

 

[JANR]

In the same report, I want a field in which Addresses are displayed in one field(mixture of both languages), studentwise

See this tread perhaps: http://www.access-programmers.co.uk/forums/showthread.php?t=217993

JR

 

[satswid]

See this tread perhaps: JR

The link Did not help.

I simply need to change a report that is to add a field which is combination of two fields, one after the other, studentwise

 

[Privateer]

satswid:
"to add a field which is combination of two fields" This is asking about concatenation and you can do it on the report. In the text box on the report enter this:
=[Address_Eng] & ", " & [Address_Por]
Privateer

 

[satswid]

satswid:
"to add a field which is combination of two fields" This is asking about concatenation and you can do it on the report. In the text box on the report enter this:
=[Address_Eng] & ", " & [Address_Por]
Privateer

No dudem I an not askin avt concatenation. But I am asking of Merging two columns, eg:

Field1 Field2
a 1
b 2
c 3

Becomes:
Field3
a
b
c
1
2
3

 

[vbaInet]

In the same report, I want a field in which Addresses are displayed in one field(mixture of both languages), studentwise

Like:

Tinsel Town
XYZ Street
Bldg ABCD
-------------
Trerfmd
XYZ Aerd
Blefdg ABCD


Please help!!

So why don't you put Address_Por right under Address_Eng?

That is:

[Address_Eng]
[Address_Por]