本文介绍了VBA SQL Where语句语法的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
您好, 我一直在努力解决这个问题并需要您的帮助! 以下是重点: 希望将以下SQL引入VBA: SELECT Securities.Name,Securities.ISIN 来自证券 WHERE(((Securities.Name)喜欢[Forms]![证券搜索工具]![namecombo]&" *")) 显然是我的WHERE条件语法是错误的:
Hello, I have been trying to solve this issue for long and need help from you guys! Here is the point: Looking to get the following SQL into VBA: SELECT Securities.Name, Securities.ISIN FROM Securities WHERE (((Securities.Name) Like [Forms]![Securities Search tool]![namecombo] & "*")) Apparently my WHERE condition syntax is wrong:
展开 | 选择 | Wrap | 行号 推荐答案试试这个... Try this ... 展开 | 选择 | Wrap | 行号
也许Evans对所有威士忌都有一点意见! 尝试: Maybe Evans has a point about all that whiskey! Try : 展开 | 选择 | Wrap | 行号
也许埃文斯对所有威士忌有所了解! 尝试: Maybe Evans has a point about all that whiskey! Try : 展开 | 选择 | Wrap | 行号
更多推荐
VBA SQL Where语句语法
发布评论