Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2001

    Unanswered: Query returning zero rows

    I have a query consisting of 2 tables which returns the correct results when viewed. I now want to add fields from a 3rd table but when I insert the fields into the query, I am not getting any data.

    Can someone please tell me why this is happening


  2. #2
    Join Date
    Mar 2004

    Re: Query returning zero rows

    Can you post both queries?

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

Posting Permissions

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