查询表达式中的komma [英] komma in query expression
问题描述
我想在表格中找到某个数字。数字是两位数。
例如我想要找的数字是t = 0,91
我用dlookup尝试了这个(ID, table,"number = 0,91")
但是这会导致错误"表达式中的komma"。我试过格式但是无法解决这个问题?问题
我该如何解决这个问题?
谢谢
Jantje
你好Jan,
DLookup()语法需要String参数,所以你需要将它们用引号括起来。例如,您可以这样尝试:
DLookup("ID","表格","数字= 0.91")
<希望它有所帮助......
I want to find a certain number in a table. The numbers are two digits.
for example the number I want to find is t = 0,91
I tried this with dlookup(ID, table, "number= 0,91")
however this results in an error "komma in expression". I tried with format but could not solve this simple? problem
How can I solve this ?
thanks
Jantje
Hi Jan,
The DLookup() syntax requires String arguments, so you'll need to enclose them in quotes. For example, you could try it this way:
DLookup("ID", "Table", "Number=0.91")
Hope it helps...
这篇关于查询表达式中的komma的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!