1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Access 2000- Change upper case to lower case

Discussion in 'Business Applications' started by Frank C, Feb 20, 2003.

Thread Status:
Not open for further replies.
Advertisement
  1. Frank C

    Frank C Thread Starter

    Joined:
    Jan 17, 2003
    Messages:
    6
    I created a list of companies & phone #'s etc. in access 2000. The letters are upper case. How do I change upper case listings to lower case?
     
  2. THoey

    THoey

    Joined:
    Feb 12, 2001
    Messages:
    3,420
    Run an UPDATE query using the LOWER() function:

    From the help:

    LOWER
    Converts all uppercase letters in a text string to lowercase letters.

    Syntax

    LOWER(text)

    Text is the text you want to convert to lowercase. Characters in Text that are not letters are not changed.

    There is also a PROPER() function that will do the following:

    ACME, INC. to Acme, Inc.
     
  3. Frank C

    Frank C Thread Starter

    Joined:
    Jan 17, 2003
    Messages:
    6
    I'm not sure about how to initiate the lower function....
     
  4. THoey

    THoey

    Joined:
    Feb 12, 2001
    Messages:
    3,420
    UPDATE [MyTable]
    SET [MyTable].[MyField] = LOWER([MyTable].[MyField]);
     
  5. Frank C

    Frank C Thread Starter

    Joined:
    Jan 17, 2003
    Messages:
    6
    I ran a Query (simple), couldn't figure out how to run a UPDATE..
     
  6. THoey

    THoey

    Joined:
    Feb 12, 2001
    Messages:
    3,420
    After you have created the query, there is a drop down on the menu bar that says "Query Type". If you drop that down and select "Update Query" it will change it.
     
  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/119875

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice