Hi
I have this Dlookup in my form in the source control o f a field but it does not work
=DLookUp([CALENDAR.FIN_MONTH],[CALENDAR],[TIME_DATE]>[CALENDAR.FIN_START] And DatePart("yyyy",[TIME_DATE])=[CALENDAR.FIN_YEAR])
the form is based on Timesheet table and I am trying to find a month in the calendar table based on the timesheet timedate.
Please hel pme
Thank u
I have this Dlookup in my form in the source control o f a field but it does not work
=DLookUp([CALENDAR.FIN_MONTH],[CALENDAR],[TIME_DATE]>[CALENDAR.FIN_START] And DatePart("yyyy",[TIME_DATE])=[CALENDAR.FIN_YEAR])
the form is based on Timesheet table and I am trying to find a month in the calendar table based on the timesheet timedate.
Please hel pme
Thank u