MS ACCESS TABLE

Results 1 to 2 of 2

Thread: MS ACCESS TABLE

  1. #1
    EH Guest

    Default MS ACCESS TABLE

    Help,<BR><BR>I need to setup a table that will allow user eventually to sort by category and list all records. The problem is that the item can be in multiple category and when a list is done I get the item listed twice because it in two categories.<BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    24

    Default RE: MS ACCESS TABLE

    Instead of having one value in your "category" field, and then multiple entries for one record that is in multiple categories, try putting multiple categories in the category field.<BR><BR>So if an item only has one category, its category field would look like this:<BR><BR>News<BR><BR>If it was in three categories, it would look like this:<BR><BR>News;General;Notes<BR><BR>Then, you can use the Split command to split up the values in the category field.<BR><BR>Good Luck<BR><BR>Hank

Posting Permissions

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