S
sidata
I need to get the month part of date and then look for that in a text feild.
E.g
Date = 15/08/2003
I need to get "August" which i can do by setting [Date] text box format to
mmm.
But then I need to look up "August" in Buget Table in the Month coloum.
I have tryed Dlookup("[Month]","Buget Table", "[Month]=[Date]")
What is need to make this work?
E.g
Date = 15/08/2003
I need to get "August" which i can do by setting [Date] text box format to
mmm.
But then I need to look up "August" in Buget Table in the Month coloum.
I have tryed Dlookup("[Month]","Buget Table", "[Month]=[Date]")
What is need to make this work?