how to enter data inbetween "text"

DeanRowe

Registered User.
Local time
Today, 21:40
Joined
Jan 26, 2007
Messages
142
Hi,
This is probably the easiest thing in the world to do but I've been beating my head against the wall for some time now.

I'm trying to print out my customers information in a letter, using a report.

For example, a customer asked for a price on a product, I enter the data on my form and when I press print I want it to look like this:

"Hi [Joe Bloggs],
Thanks for contacting us regarding the price of an [Apple].
I can supply it to you for only [£1] including VAT and Delivery.

Many Thanks"

when I try "Hi" ContactFirstName, and I go to print from my form it asks for a parameter value.

Can anyone help please? It would be greatly appreciated!
 
"Hi" & [ContactFirstName]

Offcourse contactfirstname must be a field in the query that is the recordsource for the report.
 

Users who are viewing this thread

Back
Top Bottom