Look up Error

[Guest]

I have a table called "daily kpis" that looks like this:
Split/Skill Date Calls Presented
Totals 9258
MS PA French 2/21/2007 1828
MS PA Italian 2/21/2007 1292
MS PA Spanish 2/21/2007 680
MS Arabic 2/21/2007 223
I use the following code to display the value of "calls presented" in an
unbound textbox
=DLookUp("calls presented","daily kpis","[split/skill]='ms pa french'")
But i get an error,could anybody help ?

 

[Rob Parker]

Hi Pietro,

Since you have spaces in your field and table names, you need to surround
them with square brackets. Try:
=DLookUp("[calls presented]","[daily kpis]","[split/skill]='ms pa french'")

Also, you should not use "Date" as a field name, since it's a reserved word,
and will possibly cause problems due to confusion with the built-in Date
function.

HTH,

Rob