Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    35

    Unanswered: calculated field in query

    I have a query that gives me the result as letter (a, b, c, etc....).

    How would I write a calculated field so that result would be the next following letter.

    Example: the query gives me "C" but next to this column I want "D".

    Any suggestions???

    I was thinking of something like [column]+1????

  2. #2
    Join Date
    Jul 2002
    Posts
    35
    I guess I figured it out, In case you are interested this is what I did.

    In the table where I have the letter I am obtaining, I just added another field and added what would be the following letter.

    So the table lookes like this

    Column 1-Column 2
    A-B
    C-D
    E-F
    G-H
    etc.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •