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 MikeeOK 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: john6767
  • Content: Threads
  • Order by date
  1. john6767

    distinct not working for me..

    ok i have some sql and i am trying to show all 'people' in my database, the problem arises because i am joing an 'areas' table which has a one to many relationship with my 'people'(in this case tradesmen and the areas is the areas that they service..) so i am getting as a result a list of all...
  2. john6767

    help with a simple access update query

    Hi guys, i'm new to access, have done a little sql before and am trying to to sort out a table i have been given. It has in one column 'productBrand:productCode' and i am trying to split the data that is seperated by the ':' up into two seperate columns, brand and code. I have been typing the...

Part and Inventory Search

Back
Top