dlookup #error

[jedrtd]

=DLookUp(&quot;[PMrate]&quot;,&quot;rategood&quot;,&quot;weight1> =' &quot; & Form!weight & &quot; ' And weight2< =' &quot; & Form!weight & &quot; ' &quot


Here is the lookup, I know it is just the &quot; ' are in the wrong place

thanks

 

[JoeMiller]

Try this:

=DLookUp(&quot;[PMRate]&quot;,&quot;RateGood&quot;,&quot;[Weight1] >= '&quot; & [Forms]![MyFormName]![Weight] & &quot;' AND [Weight2] <= '&quot; & [Forms]![MyFormName]![Weight] & &quot;'&quot

HTH Joe Miller
joe.miller@flotech.net

 

[jedrtd]

=DLookUp(&quot;[PMRate]&quot;,&quot;RateGood&quot;,&quot;[Weight1] >= '&quot; & [Forms]![rates]![Weight] & &quot;' AND [Weight2] <= '&quot; & [Forms]![rates]![Weight] & &quot;'&quot

ok I I pasted it just like you had it and got a name? error, put rates in place of myformname now I get Error?

not sure what to change now

any help would be great

 

[JoeMiller]

Is your text box named PMRate, Weight1 or Weight 2? If so change it. Are the Weight1 and Weight2 text datatype or number. If text should be fine, if number then you need to remove the single quotes.

HTH Joe Miller
joe.miller@flotech.net

 

[jedrtd]

pmrate is the field I im pulling the looked up value from
weigth is the field on the form

weight1 is the lowest weigth on the same table as pmrate
weight2 is the highest weight on the same table as pmrate

the weight1 and 2 fields are single/general number 4 dec.
the pmrate is money

 

[jedrtd]

I took out the single quote and I dont get an error but it isnt doing anything now
=DLookUp(&quot;[PMRate]&quot;,&quot;RateGood&quot;,&quot;[Weight1] >=&quot; & [Forms]![rates]![Weight] & &quot; AND [Weight2] <= &quot; & [Forms]![rates]![Weight] & &quot;&quot

 

[JoeMiller]

Well the DLookup syntax looks correct to me, did you misspell the name of the control itself? I notice that you typo'd weight as &quot;weigth&quot; twice in your post, perhaps you did that when you named the control?
Joe Miller
joe.miller@flotech.net

 

[jedrtd]

Ok, I tried it with each one separate and they worked pasted below are the 2 that worked

DLookUp(&quot;[PMrate]&quot;,&quot;rategood&quot;,&quot;[Weight2] =&quot; & [Forms]![rates]![weight])

DLookUp(&quot;[PMrate]&quot;,&quot;rategood&quot;,&quot;[Weight1] =&quot; & [Forms]![rates]![weight])

so now I want to do =><= with and now if I could just get the &quot; ' and () right I think it will work,

thanks