Please find the attachment of Database.
Contain One Table with FirstName, LastName, Age, Amount.
Unable to design a Report with the Columns; FirstName+LastName, Age, Amount.
Tried a lot with =[FirstName] & " " & [LastName] in a text box.
Please find the attachment of Database.
Contain One Table with FirstName, LastName, Age, Amount.
Unable to design a Report with the Columns; FirstName+LastName, Age, Amount.
Tried a lot with =[FirstName] & " " & [LastName] in a text box.
Reports are based on a record source, usually a query as you are getting data from multiple tables. Get all the data FIRST and get the query working before creating the report. Then in the control source for your objects on the report, you can pick a field that exists in the record source (let Access show you the list).
As Aytee111 says, and for the name in the query of the reports would be FullName: [FirstName] & " " & [LastName]
Depending on what you need done, many times we use [LastName] & ", " & [FirstName] so we can sort on that and it displays alphabetically by last name on the report.