Search results

  1. W

    Using subquery to return top 1 record within groups of records

    Hi Bob Sure please find a copy of the database attached.
  2. W

    Using subquery to return top 1 record within groups of records

    OK Im not getting that. Please see attached screenshot NB Im using Access 97
  3. W

    Using subquery to return top 1 record within groups of records

    Hi there I tried using that but got an error message 'Syntax Error in FROM Clause'
  4. W

    Using subquery to return top 1 record within groups of records

    Hi there I have an Access 97 database with a table called tDespatch Now this contains group of records which have a Order_Number Columns in the table are as follows: Serial_Number Sales_Order_Number Despatch_Date RepCalNumber Now there are repeating groups of records which contain...
Top Bottom