Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2004
    Posts
    78

    Unanswered: LOOKUP on a Query, not an update Query

    I used the VLOOKUP in excel. I would like to use the same idea in Access.
    Table 1 = MyFirstTable
    Field1 = ItmeName
    Field2 = Quantity

    Table 2 = MySecondTable
    Field1 = ItmeName
    Field2 = Quantity

    I have a query name qMyFirstTable

    I would like to add a column in this query that looks in MyFirstTable and returns the Quantity for each item. If it can not find an item, it should return an X

    If an update query is faster, I will go for an update query.

    Thank you
    Joe

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    you could use a join... but I wonder if a different table structure might help you. what is the business problem you're trying to solve?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Nov 2004
    Posts
    78
    I have 2 databases that should have the same inventory information, since one database is exporting the data into the second database overnight. However, a lot of items to not match. Both databases displays only item with quantity <> 0. Both databases have item not listed in the other database. Im in the process of identifying the problem.

    The first thing to do is to get a list of all items not listed in the other database.
    Thank you again
    Joe

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Ah, look into a "LEFT JOIN" to accomplish this. You can use the "unmatched query" wizard if you are uncomfortable with writing the SQL yourself.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  5. #5
    Join Date
    Nov 2004
    Posts
    78
    Almost there. The unmatched query only returns the unmatched items. Now, I would like to see the different on each item. How??
    Thanks

Posting Permissions

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