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!

Register Log in
  • Congratulations bkrike 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: *

  • Users: klange
  • Content: Threads
  • Order by date
  1. klange

    Query for parents with children only

    I need to write an SQL statement for ACCESS for a database with two tables with a one to many relationship I need a query that returns only parent records that have children and return the parent record only once, not once for each child. My query keeps returning the parent once for each child.
  2. klange

    Need help with a "Not in" query

    I need a query to do the following: I have a table I get from my headquarters that has cumulative data in it. I copy the data to another table that I maintain locally with extra fields and records that hold locally significant data. I need a query that will bring over new records from the...

Part and Inventory Search

Back
Top