Concatenate Error: It's just blank!

  • Thread starter Thread starter VirginiaKay
  • Start date Start date
V

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
 
Is MapNo a text field? If yes:

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