Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. robgoose

    Delete query in a one to many relationship.

    When I link the tables left and right to create a query to use to delete I get more instances than I want.
  2. robgoose

    Delete query in a one to many relationship.

    I would like to remove each instance from Table B that is included in Table A. There are multiple instances of the same data in A and B. But I only want to remove the number of B instances of a given combination from A.
  3. robgoose

    Delete query in a one to many relationship.

    I have recieved some assistance from some of you all but... I will be as clear as possible. To simplify it I have two tables with two fields that will have some repeating data and some unique data. Here is the picture. table A table b num let num let 1...
  4. robgoose

    Exception Query in access

    I think this might be neat. I have two tables that have three fields that MAY be identical. I want to link the two tables and run a query that only returns the fields that are NOT identical. Any information would be highly appreciated.

Part and Inventory Search

Back
Top