Forum Discussion

jesgonny's avatar
jesgonny
Copper Contributor
Mar 17, 2021

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...
  • Karl_Donaubauer's avatar
    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

Resources