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

    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

    Thanks.

  2. #2
    Join Date
    Mar 2004
    Location
    www.scirocco.ca
    Posts
    346

    Re: Query returning zero rows

    Can you post both queries?
    http://www.scirocco.ca/images/banner...occobanner.gif

    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
  •