Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2001
    Posts
    336

    Unanswered:

    The best solution would be to base your report on a query which returns only one row.

    Here is an example (MS Access 2000 Help) how to achieve it:

    SELECT TOP 1
    FirstName, LastName
    FROM Students
    WHERE GraduationYear = 1994
    ORDER BY GradePointAverage DESC

    HTH, Igor

  2. #2
    Join Date
    Dec 2001
    Location
    Virginia
    Posts
    1
    Thanks, Igor. I will try it. Thanks again.

Posting Permissions

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