Search results

  1. S

    Update Query Question

    I am working with a linked .dbf file. It has a field named GENERIC. Certain bytes in that field represent different things. The 5th byte through the 19th is the occupation of the person the record represents. I know how to update that occupation from another table. Say its coming from...
  2. S

    help with a text field

    I have a text field where the records are currently 1...next record 2, next record 3....up to 953. I am going to export this Access database to a dbf file. What I want is: That field to be 5 characters long. and right justified. so the first entry would be four space2 and then 1, four spaces...
  3. S

    Adding a string to the end of a field

    I have a field that contains various text....(It's a note field that allows 86 characters). I want to go in to the database and add the string "Conversion 2007" to the end of every record. So leave whatever is in there but add in the string. I would like it to add whatever it will fit, in the...
  4. S

    Beginner Update Query

    I think my question is easy...just not to me. I want to make a query that changes byte 75 in a certain field to a capital P. I also need to change byte 199 to N and 200 to S. Any help would be greatly appreciated.
Back
Top Bottom