Load values from the table into the text

[Max_hugo]

I have a question for my "TEST" report in the database in which I would like to add values from my "Table" database in the text. I tried to apply a label but I don't know how to add "Table" values to it.

Test text field Test text field. Test text field Test text field. [Address] Test text field Test text field. [First_name] Test text field Test text field.

In these places I would like the values to be read from the table:
[Address]
[First_name]

Thank you in advance for your answer.

 

[Joe4]

Create a new Query based on your table, and created a calculated field in that query to return that string your posted in in your initial post.
It would look something like this:

TestPhrase: "Test text field Test text field. Test text field Test text field. " & [Address] & " Test text field Test text field. " & [First_name]  &" Test text field Test text field."

So the literal parts are enclosed in double-quotes, and the variables (field names) are not, and they are combined together with the ampersand (&).

Then, create your Report using this Query, and display the calculated field on it.