Search results

  1. G

    String Manipulation: Cleaning up address labels

    Doug, Right([FULLNAME], Len([FULLNAME]) - InstrRev([FULLNAME]," ")) This was right on the money!... This formula extracted last names perfectly, no errors on all 331 records. I was able to import all records into Windows Address Book. My mother can now sort/delete and maintain her Christmas...
  2. G

    String Manipulation: Cleaning up address labels

    Doug, Why does this Extract Last Name formula only return partial last name results?: Right([FULLNAME],InStr(1,[FULLNAME]," ")) (see attched PDF)
  3. G

    String Manipulation: Cleaning up address labels

    Doug, If I could pick your query skills to help me understand the following formula; Before you sent me your query, this is what I found at: www.techonthenet.com... http://www.techonthenet.com/access/queries/extract_lastname.php ================================================== The...
  4. G

    String Manipulation: Cleaning up address labels

    Doug, Query Round#2... 99% Success (5 records unprocessed due to "lock violations") Don't know what caused those skipped records?? Great work. Thanks!... and my mother thanks you!
  5. G

    String Manipulation: Cleaning up address labels

    Doug, Query#1... 99% Successs!! (all but about 4 records) Correct, I originally ran the first query in design grid...went SQL view for success.
  6. G

    String Manipulation: Cleaning up address labels

    Syntax error message was: "...invalid syntax, or you need to enclose your text data in quotes." "You may have entered an invalid comma or omitted quotation marks."
  7. G

    String Manipulation: Cleaning up address labels

    TITLEUPDATE is the name of the copied database. I did a search a replace on your formula to replace MyTable with table TITLEUPDATE. I copied the following formula into the Update Query "Update To" UPDATE TITLEUPDATE SET TITLEUPDATE.LastName =...
  8. G

    String Manipulation: Cleaning up address labels

    Yep, ....except for "Hon." for Judge and the names with no titles (null).
  9. G

    String Manipulation: Cleaning up address labels

    Unfortunately, Text To Columns appears to be working the field from Left to right which is giving my consistent results for the first few consistent characters "Mr." or "Mrs."... but the remaining words are being scattered across different columns on each record, because each field record has...
  10. G

    String Manipulation: Cleaning up address labels

    You are exactly right... this is turning into rocket science. Thanks for saving me tons of time! -G
  11. G

    String Manipulation: Cleaning up address labels

    Extract/split lastname? How do I extract/split only the last name from a field? I have a field FULLNAME with over 300+ entries in the following format: Mr. Milton Allen Mrs. Daisy Brown Mr. & Mrs. G. Borden Rev. & Mrs. C. Starks Dr. & Mrs. Julius Coleman In the field FULLNAME, what does a...
  12. G

    String Manipulation: Cleaning up address labels

    Links to information would be fine... but just need simple tutorial-like instructions. Instructions I have found so far (Microsoft Online) has been too overwhelming.
  13. G

    String Manipulation: Cleaning up address labels

    PROBLEM: String Manipulation "Cleaning up Mom's Christmas address labels" I need guidance on the best string manipulation functions (Instr, Left, Right) to cleanup my mother's Christmas address list of 300+ names. I have successfully imported the text file into Excel and exported to Access...
  14. G

    Export Palm contacts to Access for purge?

    Anyone know where I can find instructions for purging Palm TX contact files? I have tried to export to Access via CSV and Tab Delimited, but cannot get Access to import the either structure successfully from the Palm. I have over 10 years of Palm contact crud I would like to purge and figured...
  15. G

    Function for combining 2 string expressions?

    Let me try and answer my own question... IIf(Expression, TrueAnswer, FalseAnswer) Expression: "any combination of mathematical or logical operators, constants, functions, and names of fields, controls, and properties that evaluates to a single value." Then a fieldname by itself can be an...
  16. G

    Function for combining 2 string expressions?

    I want to make sure I understand what qualifies as the expression in the IIf syntax: IIf(Expression, TrueAnswer, FalseAnswer) Which part of your solution qualifies as "the expression" being evaluated as true, the fieldname by itself or the Format statement?: A.) [testdate] B.)...
  17. G

    Function for combining 2 string expressions?

    Thank You, Thank You!!!! I had experimented with IIf function, but I had it backwards; I had the "No Exam Found" as the first expression (?) following NZ([testdate]]). I tried flipping it around just for the heck of it, but it kept giving me syntax errors which I kept failing to debug...
  18. G

    Function for combining 2 string expressions?

    I am having a conversion problem combing the following 2 string expressions. Condition 1: Format([TestDate],'mmm dd", "yyyy') Condition 2: NZ([TestDate],"No Exam Found") I want to convert the dates to string values, and evaluate for Null fields, if Null display "No Exam Found."...
Back
Top Bottom