Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    300

    Red face Unanswered: Problem with Select in PICK LIST

    When using a control with the following SQL - SELECT [I Key Sort].[Invoice Key], [I Key Sort].Name
    FROM [I Key Sort];

    It works on all selected records in the list except the last two records. It does not return the data from the table. I thought it may be corruption, so I ran the compact/repair but it did not work, same results.

    Any ideas what to try?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Can you provide us with sample data from the offending table; make sure you include the 2 records not included (highlight them too please!).
    George
    Home | Blog

Posting Permissions

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