Forum Discussion

Copper Contributor

Mar 17, 2021

Solved

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...

Doc2.doc678 KB

access

Karl_Donaubauer
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

Karl_Donaubauer

MVP

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

jesgonny

Copper Contributor

Mar 19, 2021

Thank you so much Karl for your assistance, yes I did it one step at a time and it worked this will be the formula: =([FirstName] & " " & [LastName] & " ,a " & [Title] & ", is requesting " & [Hours] & " hours of an Advance of Time.")