Using a Query for a mail merge.

[Guest]

When creating a query that looks for particular values in certain fields, I
have decided that I would try to be clever and make a new field, in the
query, calculated on two other ones. In the query in question I have decided
to use the CONCATENATE function to the FirstName Field and the Surname field,
also including " " in between. so in my case I have created a new field
called NAME

I have entered the following into a new column of the design view of a query:

Name: [FirstName]&" "[Surname]

When ran, this query does exactly what I want, would like, it to do. It
shows me both of their names in a more informal manner (The answers) to the
questions or criterias that I have written in the other fields.

I have saved this query and then tried using it for the source of a mail
merge. My other field's criteria was NO (the field, Paid?)

Can anyone tell me why Word can't find me new NAME field, when I select my
query as the source? It finds all of the other fields that are directly from
tables , but won't find this "temporary" one. (Excuse the bad spelling)

If you can help me, I'd much appreciate it

Look forward to hearing any suggestion you can throw my way

Dan

 

[Guest]

'Name' seems like it should be a reserved word. I know there's a Name
property to every object. So, try making the field MyName or TheName or
Snicklefritz and see if the problem subsides.

Steve Clark, Access MVP