accsss中虚拟字段 想作为关键字去匹配另一张表

可是好像不行，管理员请看程序

SELECT T1.会员编号 AS 会员编号, T1.会所 AS 会所, IIF([T1].[销售日期]<#2016/1/1#,0,IIF([手环].[字段2]=[T1].[会所]&[T1].[CMDOCO],[手环].[金额],0)) AS 手环金额, IIf(T1.销售日期<#2016/5/1#,1,IIf(T1.销售日期>=#2016/5/1# And T1.销售日期<=#2016/6/30#,1.06,1.03)) AS 税率, IIF(T1.[名称(1)]=卡种年限.[卡种名],卡种年限.[卡种],0) AS 卡种名称
FROM ((select *from [Sheet1$] IN "D:\Users\peifeng.huang\Desktop\会籍直线法 - access测试用.xlsx" "EXCEL 8.0;"
)  AS T1 LEFT JOIN 手环 ON [T1].[会所]&[T1].[CMDOCO]=[手环].[字段2]) LEFT JOIN 卡种年限 ON T1.[名称(1)]=卡种年限.[卡种名];

然后后面我想用卡种名称去匹配另外一张表，匹配表的时候下面肯定要用left join做链接，好像不行，要报错