I have an expression in a query called "TrnsplWk" that properly calculates a date.
I want another expression using the dlookup function that looks up the value in the [wkid] field in the wktable domain where the value of the [date] field = the result of the "TransplWk" expression.
Here is my expression that successfully calculates the date:
TrnsplWk: [readyschedule.rdyweek]-(7*[finishtable.fingrwwks])
Trying to use the expression as the criteria in the dlookup function:
TrnsplWkID: DLookUp("[wkid]","wktable","[date]=[readyschedule.rdyweek]-(7*[finishtable.fingrwwks])")
results in the error: Invalid bracketing of name '[readyschedule.rdyweek]'
When I remove the brackets from the fields readyschedule.rdyweek and finishtable.fingrwwks fields in the expression, then i get this error message:
"can't find the name 'readyschedule.rdyweek' you entered in the expression.
How can I use the date in calculated in the TrnsplWk expression to look up the respective value in the wktable domain? Is the problem using a date value? Is it simple syntax?