data report fields display

Anybody know how to display two fields on a data report and get rid of trailing spaces?

for example, I need to display "lastname, firstname"

How do I get rid of the trailing spaces after the last name so it doesn't look like this:

NAME: Smith ,John

any ideas? Is it something I have to fix on the report itself or the query behind it?

thanks
kristin

use something like in a text box in the report

[lastname] & ", " & [firstname]

You can do it either in the query behind the report so it would read somthing like

contact name:[table name]![lastname] & ", " & [table name]![firstname]


hope this helps

Since my query is generating the report, I can't do anything inside the report, as they are all bound fields. When I try to fix the query, it gives me an error. This is SQL by the way. Here is my query, any idea how to do it from here?

SELECT records.reportcontact, company.company, records.lastn,
records.firstn, records.donorid, records.collecteddate,
records.reason, records.lab, records.speciminid,
records.reportdate, records.verifieddate, records.result,
records.mrocomid
FROM records INNER JOIN
company ON records.mrocomid = company.mrocomid
WHERE (records.recordnum = ?)

Would be nice if these reports could do more.