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 biv343 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. 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...

Part and Inventory Search

Back
Top