Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Unanswered: Numeric field and text value

    I have a field which stores marks secured by students in an exam. Problem arises while recording absent students. "A" or "Abs" has to be mentioned. Creating a separate column to record absence is the only solution or is there any other way out?

  2. #2
    Join Date
    Sep 2003
    The extremely Royal borough of Kensington, London
    Access 2002,

    Select IIF(result IS NULL, "A", result) from table
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

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