dlookup

[Guest]

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?

 

[Guest]

Kate

You should be able to just criteria in your query for this. Something like:-

SELECT Table2.WeekNo, Table1.AdmitDate
FROM Table2, Table1
WHERE Table1.AdmitDate Between Table2.Start And Table2.End;

should do the trick.

Hope this helps.

Andy

 

[Guest]

Hi Kate,

Try using this expression as the control source for a text box:

=DatePart("ww",[Admit Date])


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________