Search results

That was the first thing I tried and it did not work, but I just found that the format of the field was text, so I changed that to date and now it works. Thank you for your help!

Thank you. The name of the query with the record set is QI_GAP_REPORT.

Hi, I've read several discussions on here and still have not been able to find a solution to my problem. I'm wanting to display the max date of a field in a text box on my report. I've tried the following: =DMax("[HbA1c_Test_Date]","QI_GAP_REPORT") w/and w/o brackets/quotes on each...