Query not working

[RN]

This is so stupid. I know that I am missing something really basic here but
I just can't get this to work. and I've been looking at this monitor for
way too long. Can someone please tell me why?

SELECT Comments
FROM [Tech Trng History]
WHERE ([Tech Trng History].First_Name+' '+[Tech Trng
History].Last_Name)=(qTemp.Name);

The query is pretty simple. I have one table and one query:

[Tech Trng History] [qTemp]
First_Name Name (First_Name + ' ' + Last_Name)
Last_Name
Comments

I am simply trying to get the Comments from [Tech Trng History] for the list
of names in [qTemp].

All help is welcome and needed. Thanks all.

 

[Duane Hookom]

Try something like:
SELECT Comments
FROM [Tech Trng History], qTemp
WHERE ([Tech Trng History].First_Name & ' ' &
[Tech Trng History].Last_Name)=(qTemp.Name);

I would question using Name as a field name since every object has a name
property.

 

[RN]

Thanks, that didn't workout like I planned it but it did make me realize
that I was asking the wrong question. Once I figured that out the answer
came pretty easily. Thanks agian.

Try something like:
SELECT Comments
FROM [Tech Trng History], qTemp
WHERE ([Tech Trng History].First_Name & ' ' &
[Tech Trng History].Last_Name)=(qTemp.Name);

I would question using Name as a field name since every object has a name
property.

--
Duane Hookom
MS Access MVP
--

This is so stupid. I know that I am missing something really basic here
but I just can't get this to work. and I've been looking at this monitor
for way too long. Can someone please tell me why?

SELECT Comments
FROM [Tech Trng History]
WHERE ([Tech Trng History].First_Name+' '+[Tech Trng
History].Last_Name)=(qTemp.Name);

The query is pretty simple. I have one table and one query:

[Tech Trng History] [qTemp]
First_Name Name (First_Name + ' ' + Last_Name)
Last_Name
Comments

I am simply trying to get the Comments from [Tech Trng History] for the
list of names in [qTemp].

All help is welcome and needed. Thanks all.