General message box on report

[stevekos07]

I must be having a brain fade, but I just can't work out how to incorporate an unbound text box that I can edit to appear on a report. The report's source query is a parameter query. I want to be able to have a general message box on the report to convey monthly messages to recipients.

I have tried an unbound text box, but when I run the report it asks me to specify the contents of the text box. This is not practical. If I use a text box bound to a table, I am still asked to specify a parameter. I think it is because each message has a date associated with it.

How do I specify that the message with the latest date is the one I want in that field?

Any assistance is welcome.

 

[pbaldy]

You can try using DLast() in the textbox, but it's often unreliable. You can use a DLookup() with a DMax() in the criteria to find that last date.

 

[stevekos07]

You can try using DLast() in the textbox, but it's often unreliable. You can use a DLookup() with a DMax() in the criteria to find that last date.

Yes of course! DLast( worked fine.

I knew that I knew the answer but sometimes I forget that I know .

Thanks pbaldy!

 

[pbaldy]

Happy to help! First and Last can act funny if you're not careful:

https://support.microsoft.com/en-us/kb/208190