Access 2007 Report

[Colin Airlie]

Hi there, I've created a report in Access 2007 for my MySQL college course. The report is fine and will get me a pass, but I'd like to make one more wee change to it (cosmetic, really).

The CONCAT function in MYSQL I have found really handy, but can anyone tell me if I can use it in my Access Report?

I have to display names of people (forenames and surnames) and I'd like to alter the design of the report so in Report View they are displayed as 'Name', and both Forename and Surname are together in one box.

My question is, can I do this? I've been advised that I can alter my table but this seems like quite a round about way to do this. I'd have though the whole idea of Report creation would be displaying your data how you would like to show it.

Any input to this would be gratefully received.

Thanks very much,

Colin