Results 1 to 2 of 2
  1. #1
    psoli is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2011
    Posts
    4

    Help creating a query to cross reference data.

    Hi all - rusty access skills letting me down.



    I need to create a query to cross reference say, Table A, Column X and Table B, Column X for corresponding values, and where it finds them pull the values from the row.

    Along with this, there are duplicates in B-X - this column contains part numbers, B-Y contains descriptions for the parts that are not duplicates, and B-Z, urls which are not duplicates.

    I was hoping someone could help, or give me some pointers as to how to design a form which runs the query, which reports to another form in which I can select from a list of all the rows with the same part number and a way to place those into yet another form which runs a query to place this data into a table - to export as CSV.

    It's a big ask for someone who hasn't used Access for 5 years, but it's not a terribly complicated database as they go, and I'm sure I should be able to manage it with a few tips.

    Best regards.

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    well when in design view of a query, a simple join line between the X columns of those two tables is the first step.

    This will result in records where a common value exists. The B table will, as you note, have multiple records.

    Don't follow as to then what you seek - in terms of dealing with those duplicates.

    Not sure this helps much.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to reference data without using Dlookup()
    By HunterEngineeringCoop in forum Programming
    Replies: 7
    Last Post: 12-01-2010, 09:22 AM
  2. Replies: 0
    Last Post: 07-20-2010, 12:44 PM
  3. Creating a reference to the subform.
    By evander in forum Forms
    Replies: 2
    Last Post: 05-26-2010, 09:39 AM
  4. Cross check data from 2 sources
    By Zukster in forum Queries
    Replies: 7
    Last Post: 09-22-2009, 10:54 AM
  5. Replies: 0
    Last Post: 08-31-2009, 10:50 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums