Results 1 to 2 of 2

Thread: Query (2003)

  1. #1
    New Lounger
    Join Date
    Sep 2006
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query (2003)

    I have three Purchase Orders, but when I run a query to drag up their info for a report, the query only registers one. I have no parameters or filters preventing the other two from registering in the query -- I used the wizard and made no further modifications to the query. I've checked the data and the tables recognize three different Purchase Orders, so I'm wondering what's wrong with my query.

  2. #2
    Star Lounger
    Join Date
    Jun 2004
    Location
    Lambertville, New Jersey, USA
    Posts
    82
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query (2003)

    Would need to see the query but i suspect you have the tables joined incorrectly. Right click on the join line between the tables in your query and play with the parameters to make sure you're getting "ALL"matches from the detail table.

    HTH,
    Lance

Posting Permissions

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