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 gkittelson 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. john6767

    distinct not working for me..

    thanks, i didn't know about using or group by, great help! yes it doesn't matter what is in the areaID but i need it for a search i'll include in the 'where' clause later..
  2. 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...
  3. john6767

    help with a simple access update query

    perfect, that saved me a whole heap of time, cheers!
  4. john6767

    help with a simple access update query

    ok, i'm stupid, i just worked access out, the sql does actually work i was viewing not running the query, but still this will only get the brands into another table, how would i grab the info after the ':' and put that into another column? is this possible? i'm not too keen on updating a 5000+...
  5. 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