IS this DLOOKUP possible within a query?
On 26 Jun, 10:24, "Allen Browne" wrote:
Put the = inside the quotes, and concatenate with &.
Look at the link in the previous reply if you are still stuck.
--
Allen Browne - Microsoft MVP. *Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Stu" wrote in message
...
Sorry, me being stupid :-)
This is what I should be using and *still can't get it to work.
DLookUp("WkInd","tblWeekNum","WkYr" =
(Format([AK_DELIV_DATE],"wwyy")))
Thanks Allen - got it now.
|