DLookup

[ukmale65000]

I have a table called weeknumber in which i have 3 fields. Field one
is weeknumber and contains a list of numbers 1 - 52, field 2 is called
fromdate and contains a date to define the start of a week, field 3 is
called todate and contains the date that defines the end of the week.
What i am trying to do is display the week munber in a form but am not
sure of the correct Dlookup string i need and where to place it within
the textbox criteria.
Can anyone help?

 

[stopher]

Hi

Something like this should do the trick:

=DLookUp("[weeknumber]","weeknumber","#" & Date() & "#" & " between [fromdate] and [todate]")

hth
Chris

 

[stopher]

Sorry, I forgot to mention, I assumed you are wanting to know the week number for today's date.

Chris

 

[ukmale65000]

Thanks Chris that worked a treat