Hi I cant seem to get my head round this, im trying to lookup 2 fields in a xls file with 2 criteria's in my dlookup,
this is what my code looks like for lookup of 1 field;
=Dlookup("morning","JulyLinked',"day=" & day(date()))
this works for looking up the day field in the linked table julylinked and matching this up with the day in that day.
but what im trying to do is match up the day as well as the month so my code looks something like this:
=Dlookup("morning","JulyLinked',"day=" & day(date())and "month=" & month(date()))
but doesnt work
any ideas?
this is what my code looks like for lookup of 1 field;
=Dlookup("morning","JulyLinked',"day=" & day(date()))
this works for looking up the day field in the linked table julylinked and matching this up with the day in that day.
but what im trying to do is match up the day as well as the month so my code looks something like this:
=Dlookup("morning","JulyLinked',"day=" & day(date())and "month=" & month(date()))
but doesnt work
any ideas?