Help Dlookup with calculated date criteria not working

[penndro]

I would apprecite your help in looking at this formla and helping to troubleshoot what I did wrong. I have tried many ways to get this to work.

? DLookUp("[Close] ","[ref_Stock Index]","[ref_Stock Index]![stockDate]= #" & [Grant date]+[vestdays] & "#")


Stockdate - in the look up table
[grant date]=date value, [vestdays]=#days these two added together create the date I need to use for the lookup in the table

 

[dhookom]

What happens when you try the expression you provided?

Duane
Hook'D on Access
MS Access MVP

 

[penndro]

Hi Duane,

Thanks for looking at this. I get a compile error: External name not defined.

 

[dhookom]

What are you attempting to do?
What does this mean?

I need to use for the lookup in the table

Duane
Hook'D on Access
MS Access MVP