SOLVED

MS Access Reports

New Contributor

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([FirstName] & ", " & [LastName]) + “a” &( [Title]) +”is requesting ”& ([Hours]) +” hours of An Advance of Time”

 

but i don't know how i can properly do the expression so i can include the text in an unbound text field ( combination of text from a query and added text that doesn't change)

 

on the attached document is the design view of the report and the report that i'm trying to do ( as sample the first paragraph all the information together but will change the name, title and amount of hours)

 

Thank you,

3 Replies
Unable to read the content in attached file,,, better take a screen shot & save as PNG/JPEG file & then Share with us!!
best response confirmed by jesgonny (New Contributor)
Solution

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

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