Concatenating fields in a single Report column!!!Help Plz

[GirishBreakTheRules]

Hey guys,

I developed a system for Scholarship. i have one main table:Applicant and all other tables(Like school certificate results, Alevel result,Scholarship...) join to it thru the applicant_id foreign key. i want to generate a report...the format is given below. All attributes on the forms are in separate fields!

Name+Surname*******OLevel Results******ALevel Result

Bob Sinclair**********maths-A********* Physics-A
******************English-B********* maths-A
******************Physics-A******** Biology-B

I just wana know how to concatenate several fields from a single table into one column header of the report?...just as shown in the OLevel results!. Can we do that in the report wizard or must we make a query manually??

 

[Lister]

In a query creat a alias and joint what ever fields in a that row that you want.

eg: Results: [FristName]&" "&[Lastname]&", "&[Result]&" - "&[Award]

Results: Dave Lister, D - None

Get the idea?
Hope this helps : )