Concatenate Error: It's just blank!

[VirginiaKay]

I was not able to just create a Concatenate Query within my original
database, so I imported my table into the example database provided by Duane.
Following the example, I also created a table that just listed the field to
group by (I have names (lessors) and tract numbers. So far, so good. It
does not give me an error message, but the field I run the concatenate in is
just blank! The query is below. What's going wrong?

SELECT MapNumbers.MapNo, Concatenate("SELECT Lessor FROM LessorNames WHERE
MapNo=" & [MapNo]) AS Lessor
FROM MapNumbers;

Thanks!
Virginia

 

[Ken Snell \(MVP\)]

Is MapNo a text field? If yes:

SELECT MapNumbers.MapNo, Concatenate("SELECT Lessor FROM LessorNames WHERE
MapNo='" & [MapNo] & "'") AS Lessor
FROM MapNumbers;