Access中备注类型的字段不能参与子查询

select *,
(
    select P1.PName
    from Property P1
    where P1.PID = GPID
) as PName,
(
    select P2.PModel
    from Property P2
    where P2.PID = GPID
) as PModel,
(
    select P3.PCID
    from Property P3
    where P3.PID = GPID
) as PCID,
(
    select P4.PDescription
    from Property P4
    where P4.PID = GPID
) as PDescription,
(
    select P5.POverhaulWay
    from Property P5
    where P5.PID = GPID
) as POverhaulWay
from PropertyEntity
where GSN = 'dggfd' and GIsScraped = 0

怎么解决呢？

子查询'  '中 Memo 或 OLE 对象无效