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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Cadteach

  1. Cadteach

    Concat

    Solved.. Thanks, used SELECT CONCAT( Remarks1, Remarks2, remarks3, remarks4, remarks5, remarks6) AS Descri FROM IdxactRs;
  2. Cadteach

    Concat

    I'm trying to combine 2 fields into 1 new field using concat. This is what I using UPDATE 'idxactrs' SET 'idxactrs.desc' = concat(remarks1,remarks2) It just says "You have an error in your SQL syntax near ''idxactrs' ... Any Ideas?
  3. Cadteach

    Import text and transform

    No, I have no idea what that is, but I'll try and look into it. I'm not a programmer, nor a database administrator, just someone who volunteered. I've downloaded phpdev, and run MySQL on my laptop as localhost, and I can create the tables, and I can dump the existing structure, I'm just...
  4. Cadteach

    Import text and transform

    I have a text file that I need to import and transform in access. The first row is a header row. I can open it in access and create the table. I need to transform some of the data. The fields currently import like this : SwimmerID 50free 50fly 50back 100IM With the records below...
  5. Cadteach

    Query Help

    Would this statement work? UPDATE tablename SET address=" " WHERE Display="N
  6. Cadteach

    Query Help

    I have a database which lists address in one field and a field named "DISPLAY" which is a Y/N field. The database gets updated weekly. All addresses are in the database originally after update. I'd like to use the Y/N field to show or delete the address field. If the field is N, then the address...
See more

Part and Inventory Search

Back
Top