multiple fields from a record within a single column

antonyx

Arsenal Supporter
Local time
Today, 06:29
Joined
Jan 7, 2005
Messages
556
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
 
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
 

Attachments

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...
 

Users who are viewing this thread

Back
Top Bottom