Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Posts
    42

    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?

  2. #2
    Join Date
    Feb 2003
    Location
    Auckland, NZ
    Posts
    150
    First of all I assume there is a date field available.

    In your sub report's record source you will have a query like

    Code:
    SELECT MemoField FROM Table;
    Change it to the following

    Code:
    SELECT TOP 1 MemoField FROM Table
    ORDER BY DateField DESC;
    JJ Kennedy
    Double J IT Solutions
    www.doublejit.co.nz

    VB 6, VB.NET, ASP.NET, MS SQL Server, MySQL, MS Access

  3. #3
    Join Date
    Dec 2002
    Posts
    42
    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •