K
kate
please could someone help me with a dlookup query.
my data in table1 [admit date] [discharge date]
in table2 [start] [end] [weekno]
i need to look at the admit date check which date period it is in (start and
end) and for it to show weekno as lookup
i have tried dlookup("Weekno","table1","Admitdate>=start" and
"Admitdate<=End")
it bringsup 1 in every field can you help?
my data in table1 [admit date] [discharge date]
in table2 [start] [end] [weekno]
i need to look at the admit date check which date period it is in (start and
end) and for it to show weekno as lookup
i have tried dlookup("Weekno","table1","Admitdate>=start" and
"Admitdate<=End")
it bringsup 1 in every field can you help?