|
专家们!你们好! 我最近在creat 一个access file, 里面有Table - Staff Remuneration & Form - Monthly Salary.
Data 如下:
Table:
Employee Name Basic Salary Beginning date Ended date
Rose RM3,000 1/1/2011 31/12/2011
Rose RM3,500 1/1/2012 31/12/2012
Form:
Salary's date Employee Name Basic Salary
31/10/2012 Rose (DLookUP expression)
我的想法是: 当我在form click Employee Name, Basic Salary of Rose 会自动显示出来。 所以我做了一个expression:
=DLookUp("[Basic Salary]","[Staff Remuneration]","[Employee Name] = " & Forms("Monthly Salary")("[Employee Name]")) ---> 这个expression 是行得通的, 但是如果有两个名字在同样的一个Staff Remuneration's form, access 就只能显示一个先有的答案, 所以我很困惑。(我的expression 一直出RM3,000 的答案给我, 其实我要的是RM3,500.)
我想把expression 写得更仔细些, 就是Basic Salary的答案是 Salary's date (Form) between Beginning date (Table) & Ended date (Table). 请问应该怎样再仔细化我的expression? 谢谢!
|
|