var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Unique value for query with a memo field
My report contains a subreport based on a query with a memo field.
I only want to display the latest date.
How do I restrict the subreport to one record?
First of all I assume there is a date field available.
In your sub report's record source you will have a query like
Change it to the following
SELECT MemoField FROM Table;
SELECT TOP 1 MemoField FROM Table
ORDER BY DateField DESC;
Double J IT Solutions
VB 6, VB.NET, ASP.NET, MS SQL Server, MySQL, MS Access