I have a qry based on a table with field [f6] as a date. For example, one record has [f6] with a value of 10/14/2008 (format m/d/yyyy).
I am building a field in that query with a dlookup into tblCalendar which looks like this:
dateStart* dateFinish* Month
8/29/2008 9/25/2008 200809
9/26/2008 10/30/2008 200810
10/31/2008 11/27/2008 200809
*both fields have date format as as m/d/yyyy
I want my query to go into tblCalendar and return the [Month] value where the [f6] falls between, or is equal to, datestart/datefinish.
My statement is:
Expr2: DLookUp("month","tblCalendar","DateStart <= " & [f6] & " And DateFinish >= " & [f6])
My query returns nothing.
I am building a field in that query with a dlookup into tblCalendar which looks like this:
dateStart* dateFinish* Month
8/29/2008 9/25/2008 200809
9/26/2008 10/30/2008 200810
10/31/2008 11/27/2008 200809
*both fields have date format as as m/d/yyyy
I want my query to go into tblCalendar and return the [Month] value where the [f6] falls between, or is equal to, datestart/datefinish.
My statement is:
Expr2: DLookUp("month","tblCalendar","DateStart <= " & [f6] & " And DateFinish >= " & [f6])
My query returns nothing.