Recent content by ogrerugby

  1. O

    Case Sensitive Update

    Thanks, looks like it will work I just did a quick test vs 2 test tables and I think the results will be correct now. Now I get to run it vs my 1+million row table. thanks again.
  2. O

    Case Sensitive Update

    Can I do it in a query.... Or do I have to write a module??? Sorry, new to access.
  3. O

    Case Sensitive Update

    Can I do it in a query.... Or do I have to write a module??? Sorry, new to access.
  4. O

    Case Sensitive Update

    I have an update query and it looks as if it was not case sensitive. Is that true or do I need to specify case sensitive in the query? Here is the query that ran: UPDATE Variations INNER JOIN EmailIndexes ON [Variations].[Variations]=[EmailIndexes].[MailTo] SET EmailIndexes.UserNameTo =...
  5. O

    Substring question

    Bingo It works. Thanks alot!
  6. O

    Substring question

    I have a quick question that should be easy but I'm fairly new to Access. I have a table with one column named "descriptor" and the data is in this format: 123-456-7890-1111 5555-6666-7777-123 45654-214-233-4562 There are always 4 values and they are delimited by "-". I just need a query to...
See more
Back
Top Bottom