[求助]dlookup不能实现的查询

loren

<>有下面一个个表：</P>
<TABLE  cellSpacing=0 cellPadding=0 width=144 border=0 x:str>
<COLGROUP>
<COL style="WIDTH: 54pt" span=2 width=72>

<TR  height=19>
<TD class=xl22  width=72 height=19><FONT face=宋体>销量区间</FONT></TD>
<TD class=xl22  width=72><FONT face=宋体>折扣率</FONT></TD></TR>
<TR  height=21>
<TD class=xl23  height=21><FONT face="Times New Roman">   1-10       </FONT></TD>
<TD class=xl22  x:num><FONT face=宋体>   0</FONT></TD></TR>
<TR  height=21>
<TD class=xl23  height=21><FONT face="Times New Roman">   11-50     </FONT></TD>
<TD class=xl22  x:num><FONT face=宋体>   85</FONT></TD></TR></TABLE>
<>    ......             .....</P>
<>如果现在销量是23，那么想通过查询确定其对应的折扣率85。如何实现？请教高手</P>

tz-chf

<>销量区间拆为两个字段</P>

loren

<STRONG><FONT face=Verdana color=#61b713>tz-chf老兄，我也是这么打算的，但dlookup条件可以是大于等于或小于等于吗？我试了不行，如何实现，请教！谢谢</FONT></STRONG>

一点通

<DIV class=quote><B>以下是引用<I>loren</I>在2007-7-26 8:24:00的发言：</B><BR><STRONG><FONT face=Verdana color=#61b713>tz-chf老兄，我也是这么打算的，但dlookup条件可以是大于等于或小于等于吗？我试了不行，如何实现，请教！谢谢</FONT></STRONG></DIV>
<>可以的,将=号改为&lt;,&gt;号就行了</P>

rjacky

<>域函数可以做到的，你的销量区间做得不合理而已，分开即可，不用拆成两字段</P>

<>
<TABLE 139pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=185 border=0 x:str>
<COLGROUP>
<COL style="WIDTH: 85pt; mso-width-source: userset; mso-width-alt: 3616" width=113>
<COL style="WIDTH: 54pt" width=72>

<TR 14.25pt" height=19>
<TD class=xl24 #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 85pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" width=113 height=19 x:str="销量区间  ">销量区间  </TD>
<TD class=xl24 #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 54pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=72>  折扣</TD></TR>
<TR 14.25pt" height=19>
<TD class=xl24 #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19 x:num>1</TD>
<TD class=xl24 #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:num>0</TD></TR>
<TR 14.25pt" height=19>
<TD class=xl24 #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19 x:num>10</TD>
<TD class=xl24 #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:num>0</TD></TR>
<TR 14.25pt" height=19>
<TD class=xl24 #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19 x:num>11</TD>
<TD class=xl24 #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:num>85</TD></TR>
<TR 14.25pt" height=19>
<TD class=xl24 #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19 x:num>50</TD>
<TD class=xl24 #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:num>85</TD></TR></TABLE></P>

<>实际折扣=dmax("[折扣]","XXX表或查询"，"[销量区间]&lt;= 实际销量")</P>