DCOUNT 函数问题

C# code

DCOUNT('g_id','guest','g_id<='&g_id&'and (shenhe='Y')')

guest 是表  

提示错误是： 语法错误 操作符丢失

大神们 看看怎么改 



------解决方案--------------------
这个看着比较奇怪

'g_id<='&g_id&'and (shenhe='Y')'

Y是变量还是literal?

要改成
'g_id<='&g_id&' and (shenhe=' &Y &')'
或者
'g_id<='&g_id&' and (shenhe=''Y'')'
吧

------解决方案--------------------
'g_id<=''' &g_id& ''' and ( shenhe=''' Y ''')'