另一个Dlookup问题...... [英] another Dlookup problem...

问题描述

我正在创建一个工作数据库，我遇到了麻烦。目前我正在使用嵌套的dlookup语句，他们正在搜索某些条件，以便找到该语句所读的正确值：


= DLookup（" [tbl Cost Center] ！[描述]"，" tbl Cost Center"，" [tbl Cost Center]！[CC] = DLookUp（" [tbl People]！[CC]"，tbl people，[ tbl People]！[EmployeeNumber] =表格！[请求]！[cmbRequestor]"）"）


我换了引号并试过上帝知道多少数字和文本的语法。第一个dlookup标准是文本。第二个dlookup标准是数字。我已经筋疲力尽了我所知道的一切。


错误信息如下：


" ...数据库无法解析表达式......"

I''m creating a database for work and i''ve run into a snag. Currently i''m using to nested dlookup statements and they are searching for certain criteria in order to find the correct value the statement reads:

= DLookup ( "[tbl Cost Center]![Description]" ," tbl Cost Center", "[tbl Cost Center]![CC]= DLookUp("[tbl People]![CC]","tbl people","[tbl People]![EmployeeNumber]= Forms![Requests]![cmbRequestor]")")

i''ve swapped the quotations marks and have tried god knows how many syntaxs for numeric and text. The first dlookup criteria is text. the second dlookup criteria is numeric. I''ve exhausted everything i know how to do.

The error message is as follows:

"...Database can''t parse the expression..."

推荐答案

= DLookup（" [Description]"，[tbl Cost Center]"，[CC] ="& DLookUp（" ; [CC]"，[tbl people]"，[EmployeeNumber] = [Forms]！[Requests]！[cmbRequestor]"））

=DLookup("[Description]" ,"[tbl Cost Center]", "[CC]=" & DLookUp("[CC]","[tbl people]","[EmployeeNumber]=[Forms]![Requests]![cmbRequestor]"))

" ...查询表达式中的语法错误（缺少运算符）''[CC] =''..."

"...syntax error (missing operator) in query expression ''[CC]=''..."

" ...查询表达式''[tbl cost center]中的语法错误（缺少运算符）！[CC] =''..."

"...syntax error (missing operator) in query expression ''[tbl cost center]![CC]=''..."

CC是文本值吗？

CC is a text value?

展开 | < span class =codeLinkonclick =selectAll（this）;>选择 | Wrap | 行号

这篇关于另一个Dlookup问题......的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！