multiple fields from a record within a single column

[antonyx]

hello, to my knowledge it is only possible to create a report in the following format..

each row represents 1 record.. and each column represents one field.

if however i wanted to include in column 1 the 'time' and 'date' (2 separate fields in my table) of record 1, and then for example the customer name and telephone number for record 1 (again two fields) in column 2, would this be possible??

i have included an illustration.. i am sure that access allows the customization of report format but im not sure if this particular feature is available.

here it is

http://bb.1asphost.com/antonyx6/DISPLAY.JPG

 

[Smart]

I have attached a quickly knocked up version of what I think you are after even if it is not quite what you are after it might lead you in the right direction

 

[Gunnerp245]

I did not look at the attached db, but wouldn't the CONCATENATE function work? It would be separate columns in the table but could be printed as one field on a report.
Gunner...