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 derfloh 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: Cadteach
  • Content: Threads
  • Order by date
  1. 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?
  2. 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...
  3. 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