Forum Discussion
jesgonny
Mar 17, 2021Copper Contributor
MS Access Reports
Greetings group, I need some assistance in MS Access Report I'm trying to create a letter report in Access using text boxes bonded to a Query and additional data as sample: =Trim([FirstNa...
- Mar 18, 2021
Hi,
I can see the picture of your report preview but it doesn't tell me anything about what you are trying to accomplish. As a general rule: If you want to concatenate strings don't use the plus sign + but always the ampersand & . Otherwise Access thinks you want to calculate with numeric values e.g. in your "Hours" field. So your expression could look like this:
= Trim([FirstName] & ", " & [LastName]) & " a " & [Title] & " is requesting " & [Hours] & " hours of An Advance of Time"
If that doesn't work try a step by step approach. Test only with the first part of the expression, then the next until you get a problem. Then post your current test expression and the error message and symptoms.
Servus
Karl
*********
http://AccessDevCon.com
https://www.donkarl.com
Rajesh_Sinha
Mar 18, 2021Steel Contributor
Unable to read the content in attached file,,, better take a screen shot & save as PNG/JPEG file & then Share with us!!