Results 1 to 2 of 2
  1. #1
    TheSpecialist is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2015
    Location
    Georgia
    Posts
    47

    Step 4 How do I show the letters and not numbers

    Hi,



    In the attachment. I want to show the letters and not the numbers that she states in step 4 How will I do this

    thank you
    Attached Thumbnails Attached Thumbnails 2015-09-16 (3).jpg  

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,648
    Show letters where? I already see letters as captions on the buttons.

    The conversion is what your table is for. The S/S field has the letter value that corresponds to the x and y (column and row, Scope and Severity) values. Just open the table and create records.

    Scope Severity S/S
    1 1 J
    1 2 G
    1 3 D
    1 4 A
    2 1 K
    2 2 H
    2 3 E
    2 4 B
    3 1 L
    3 2 I
    3 3 F
    3 4 C

    What is purpose of this form? Are you trying to use it to populate the table instead of just manually creating the records?

    Names should not have spaces or special characters/punctuation (underscore is exception). Also, reserved words should not be used as names.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 06-05-2015, 01:07 PM
  2. mix of letters and numbers on the form
    By iscinar in forum Forms
    Replies: 15
    Last Post: 10-20-2013, 06:11 AM
  3. Add letters to sequential numbers
    By bassplayer79 in forum Programming
    Replies: 29
    Last Post: 09-12-2013, 04:20 AM
  4. Sorting by Letters and then numbers with dashes
    By Analogkid in forum Queries
    Replies: 8
    Last Post: 04-29-2013, 05:05 PM
  5. IIF with numbers and letters
    By hzrdc2 in forum Queries
    Replies: 2
    Last Post: 03-28-2013, 07:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums