S
Stu
I want to create the lookup criteria from a date field withn the query
itself but can't get it to work. The lookup I'm using always returns
1 (when it should be 908,1008 etc)
DLookUp("WkInd","tblWeekNum",(Format([AK_DELIV_DATE],"wwyy")))
Is it possible to do the lookup this way and, if so, can you please
tell me where Im going wrong.
TIA
itself but can't get it to work. The lookup I'm using always returns
1 (when it should be 908,1008 etc)
DLookUp("WkInd","tblWeekNum",(Format([AK_DELIV_DATE],"wwyy")))
Is it possible to do the lookup this way and, if so, can you please
tell me where Im going wrong.
TIA