Help with DLookUp

[camidon]

I'm wanting to use DLookUp in my table to populate a field. I'm building the expression like this.

=DLookUp("[agingcat]","tblagingcat",Choose(DateDiff("ww","opendate",Date()),1,2,3,4,5,6,7,8,9,10,11,12,13,14))

It's telling me that DLookUp is not a valid function. How can I use this code on a table to populate a field.

Any help is appreciated.

Chris

 

[TTThio]

I think the function is applicable in query or form, not in table. Try to create a query with the table as source, and add a field there using dlookup.

 

[camidon]

I think you're right. I'll try to create a query with the data in it and see if that works.