in your text, replace 'John Brown' with something like {FirstLastName} and 'his' with {Gender} etc
then in the report recordsource, use a calculation something like
embedded:replace(replace([myTemplate],"{FirstLastName}",[FirstName] & " " & [LastName]),"{Gender}",[Gender])
use curly brackets for the placeholders so they won't get confused with anything else
See this youtube video from Phillip Stiefel where he shows his function and example of what you are requesting. Very, very similar to ajax's advice.
Last edited by orange; 10-31-2020 at 10:44 AM.
in your text, replace 'John Brown' with something like {FirstLastName} and 'his' with {Gender} etc
then in the report recordsource, use a calculation something like
embedded:replace(replace([myTemplate],"{FirstLastName}",[FirstName] & " " & [LastName]),"{Gender}",[Gender])
use curly brackets for the placeholders so they won't get confused with anything else
I recently started learning Access and this is my first attemtp to create a database with access. Where to add calculations? Could you please elaborate?
in your queryWhere to add calculations?
if you want, provide details of your tables and relationships and I can provide a more focused answer