Report - Function combine last name and first name

[sellis]

Doing something stupid again - I just know it. I have this function that works perfectly in a query, but when I try and introduce the same function on a report it blows up. It have a first name field and a last name field, and I need to combin them into a Full Name. I do not really want to store this as I do not see the point. I have Access 2007 and in my queries I just have First Name&" "&Last Name. Low and behold it gives me the first name a space and them the last name. I am trying to do the exact same thing for the Report, but when I try and enter this function, the report runs, but a box appears before the report comes up that has my table name and and blank and the box says enter parameter value. Then if I just hit enter the report comes up and instead of the "Full Name" I get #error. Any help would greatly appreciated.

 

[Joe4]

Store the calculation in a calculated field in a query, and then use the query as the Data Source of your report. Then just insert the calculated field into your report.

My personal preference is to attempt to do most of the calculations in the query instead of the report. For things such as totals and sub-totals, it makes sense to do them on the Report, but for single record item calculations, I prefer to do them in the query. I think it makes them easier to maintain,

 

[sellis]

Thanks. I will give it a try.