I am trying to create an Access 2010 DB that will create a report for requesting travel. The DB is all set up with Tables, Queries, forms and a Single Report.
In the report, I have a field that gives the explanation on when and where the travel will be.
"I will be traveling on [date] and going to [Location] and returning on [Date]."
What I would like to do is to have a template text and have the dates and location embedded into the text. The idea is to have a database that will record the requests and have a standardized document to be printed. The static text is a "Label" and not a text field.
Any suggestions would be great.
Thank you for your time,