Re: How to split a field into parts

Tech-Archive recommends: Fix windows errors by optimizing your registry

doyle60_at_aol.com
Date: 03/08/05 

Date: 8 Mar 2005 07:37:30 -0800

Thanks. This did it. I now have split the overloaded field into five
basic parts.

Yes, I was trying to use the InStrRev in a query in Access 2000.

Thanks so much,

Matt

Relevant Pages

  • Re: How to split a field into parts
    ... But InStrRev is not a defined function in my Access 1997. ... trying to use it in a query, ... But if I get the InStrRev to work, I could just say: ... Matt ...
    (microsoft.public.access.modulesdaovba)
  • Re: ARGH! SQL query sorted by last name when all I have is full name?
    ... I'd recommend changing the table to have separate fields ... You could then use a query using InStrRev to ... parse the existing data *within Access* before trying to use it in your ASP ... > engine doesn't support the InstrRev function... ...
    (microsoft.public.access.queries)
  • Re: InstrRev error
    ... "david" wrote: ... InstrRev was a VB function that was only added to Access VBA ... there was a list of safe expressions that you can use in a query. ...
    (microsoft.public.access.queries)
  • Re: InstrRev error
    ... InstrRev was a VB function that was only added to Access VBA ... there was a list of safe expressions that you can use in a query. ... Unless you allow unsafe expressions, ...
    (microsoft.public.access.queries)
  • Re: for
    ... >> Steve Clark, Access MVP ... >>> into a query and this gave me exactly what I was looking for ... ... >>> 'InStrRev' in expression. ... >>> Chris ...
    (microsoft.public.access.queries)