Results 1 to 2 of 2
  1. 10-14-2013, 11:59 PM #1
    yossik
    yossik is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Oct 2013
    Posts
    2

    Adding new columns of sign

    A question to you pro's...
    I have table with one of the columns with number (amount) that can be positive or negative.
    I want to add new column of sign - 'H' for positibe or 'S' for negative.

    any suggestions how to do that?
    Reply With Quote Reply With Quote
  2. 10-15-2013, 12:26 AM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,921
    Why don't you just enter a negative value into the Amount field?
    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.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Adding Columns in a Query
    By racefan91 in forum Queries
    Replies: 5
    Last Post: 10-01-2013, 02:34 PM
  2. Sign Out and Sign In Student Database
    By jamiers in forum Forms
    Replies: 6
    Last Post: 08-29-2012, 02:03 PM
  3. Supply data to 'sign out' form from 'sign in' form using common element
    By CarlV in forum Access
    Replies: 35
    Last Post: 09-19-2011, 10:13 AM
  4. Adding columns that contain blanks.
    By Tony McGuire in forum Access
    Replies: 11
    Last Post: 05-31-2009, 12:58 PM
  5. Adding Two Columns
    By arthura in forum Queries
    Replies: 6
    Last Post: 05-01-2009, 08:38 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums