Results 1 to 2 of 2
  1. 03-10-2011, 04:12 AM #1
    nianko
    nianko is offline Novice
    Windows XP Access 2000
    Join Date
    Aug 2010
    Posts
    21

    Buy/Sell field ina table

    Hi,



    Quick/easy question: what is the best type to choose, to create a field in a table (that will feed into a form) that could be "Buy" or "Sell". I would like it to be "buy" by default, because 99% of the time it will be "Buy".

    Thanks for your help.
    Reply With Quote Reply With Quote
  2. 03-10-2011, 08:29 AM #2
    SoftwareMatters
    SoftwareMatters is offline Access VBA Developers
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    I would use a Yes/No field and set it up as an option group on my form with the default being Buy (true)
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Auto fill one field based on another field in the same table
    By skourta in forum Database Design
    Replies: 5
    Last Post: 01-20-2011, 11:36 PM
  2. Update field value in a table based on the sum (or abstraction) value of other table
    By bakkouz in forum Access
    Replies: 3
    Last Post: 01-17-2011, 01:48 AM
  3. Convert form to Table or Add Field to Table
    By jlclark4 in forum Forms
    Replies: 1
    Last Post: 12-15-2010, 01:52 PM
  4. Selecting a corresponding table field based on text field.
    By michaeljohnh in forum Programming
    Replies: 5
    Last Post: 10-08-2010, 10:33 AM
  5. Update a field in a table based upon information in anther table?
    By sabrown in forum Database Design
    Replies: 4
    Last Post: 09-03-2009, 02:01 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