Group Fields?

[Tina]

Is there any way to group fields in a report.

For example: I have a Home address, Home City, Home
Province and Home Postal Code fields. In my report I
would like to have all these fields in appear as one field.

Is this possible?

And how do I change the paper size on the report to be
able to print on legal size paper.

Thanks!

 

[kip]

-----Original Message-----
Is there any way to group fields in a report.

For example: I have a Home address, Home City, Home
Province and Home Postal Code fields. In my report I
would like to have all these fields in appear as one field.

Is this possible?

And how do I change the paper size on the report to be
able to print on legal size paper.

Thanks!
.

Simple. create a text box, and under data source put the
formula: =[name] & " " & [address 1] & " " & [city]
& ", " & [state]

like that. Make sure that no field on the report has the
same name as the data field (which is what the wizard
does when it creates a report) check on the textbox
properties under other. i.e. if the name of the textbox
with datasource of 'address' is also 'address' change the
name of the textbox to something else 'txtaddress', or
remove the box.

Kip