DLookup / DMax Problem

[Rjc8513]

I have added a text box to a report which is supposed to display the latest day of the week but I am having trouble getting DLookup to work properly.

I am trying to return the latest day of the week by finding the highest day number. Sat. is [DAY OF WEEK], 1 is [DAY NO], Sun. is [DAY OF WEEK], 2 is [DAY NO], etc.

Here's my code in the Control Source property of the text box:

="through " & DLookup("[DAY OF WEEK]","[tbl DAILY DATA]",DMax("[DAY NO]","[tbl DAILY DATA]"))

Thanks.

 

[Remou]

How about:

[tt]DLookup("[DAY OF WEEK]","[tbl DAILY DATA]","[DAY NO]=" & DMax("[DAY NO]","[tbl DAILY DATA]"))[/tt]

Assuming [DAY NO] is numeric.

 

[Rjc8513]

That did it, Remou! Thank you. I was wrestling with that one for quite a while.