Results 1 to 2 of 2
  1. #1
    stubeard is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2010
    Posts
    1

    Multiple answers in one field?

    Hey everyone.



    By way of introductions, I'm a PhD student setting up an Access file for my bibliography. Basically I want to attach "tags" to each entry to say what subject area the book is related to, so that I can do a quick search to see which books come under which subject.

    However, some come under more than one. For example: Alexis de Tocqueville's Democracy in America comes under the subject "democracy" but also under "political organisation". So I'd want this book to come up in a search for both terms.

    Is there a way I can give an entry more than one "tag" like you can with mp3s in Windows Explorer, giving them more than one genre? And is there a way I can do it without setting up a field for each subject heading with a Yes/No answer?

  2. #2
    Rixxe is offline Blessed Bear
    Windows 7 Access 2007
    Join Date
    Sep 2010
    Location
    London (Essex ... yep!)
    Posts
    184
    I've never seen anything that suggests you can use a 'tag' (more than 1 result) in any field.
    You could however, use an IF statement.
    To say for example:

    IF subjectarea1 <> null
    then
    insert into
    IF subjectarea2 <> null
    else
    insert into
    subjectarea3


    Thats just an idea (That isnt proper syntax btw!) It means you wouldn't need a field for each subject area, but you would need more than one field, depending on how many areas an item can come under.
    Either way its going to be difficult (my guess anyway) as you will have to specifiy each subject area that could go into any field depending.

    Good luck

    Rixxe

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 02-28-2010, 05:46 PM
  2. Replies: 1
    Last Post: 12-10-2009, 08:41 PM
  3. Keying in Test Answers from Hard Copy
    By CityOfKalamazoo in forum Forms
    Replies: 4
    Last Post: 12-07-2009, 12:44 PM
  4. Noob needing answers
    By sartan2002 in forum Access
    Replies: 0
    Last Post: 10-13-2009, 08:39 AM
  5. Change the display of Yes/No answers
    By winter in forum Forms
    Replies: 2
    Last Post: 08-11-2009, 09:06 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums