Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Sep 2001
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multi-Value Fields in older versions (Access/2002)

    I know in the new Access 2007 there is the ability to have Multi-Value Fields and store more than one value in a field. Is this possible in 2002? For instance if you were doing a survey and used option buttons for response could you store or take two responses instead of one? For instance the options to select are 1, 2, 3, or 4. Right now you can select one but could you for instance select 1 and 4?

    The field currently is a number field and option button is used.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multi-Value Fields in older versions (Access/2002)

    if you wanted to create a "multi-value" field in Access 2003 or before, you'd have to use a text field and store the values as a comma-delimited string, e.g. "1,4". But since there is no built-in support for multi-value fields in these versions of Access, analyzing such data is a PITA. I'd prefer using a separate table in which each selected response is a record.

  3. #3
    Lounger
    Join Date
    Sep 2001
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi-Value Fields in older versions (Access/2002)

    I figured it would be a PITA but just thought I would ask. Thank you for the information.

Posting Permissions

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