Results 1 to 7 of 7

Thread: [RESOLVED] [Access2000] Return multiple fields/categories in only one field/cell

Threaded View

  1. Dec 3rd, 2007, 05:32 AM #1
    RS_Arm
    RS_Arm is offline

    Thread Starter
    Hyperactive Member RS_Arm's Avatar
    Join Date
    Mar 2007
    Location
    Planet Earth
    Posts
    282

    Resolved [RESOLVED] [Access2000] Return multiple fields/categories in only one field/cell

    Hello guys.
    I'm using an Access2000 db and I just can't change to another db to do this.

    So this is my current problem:
    I have a product table. Each product belongs to one or more category.

    DB Diagram
    Code:
    Product		| Categories	| Prod_Cat
------------------------------------------
*ID_Prod	| *ID_Cat	| *ID_Cat
Desc		| Desc_Cat	| *ID_Prod
    So, what I want to do is:
    In only one , I want to show all categories that a product belongs.

    This is what I'm getting now:

    Code:
    ID	|Desc	|Categories
--------------------------------
12	|UPS	|Power
12	|UPS	|Accessories
12	|UPS	|Obsolete


    This is how I want it to be:

    Code:
    ID	|Desc	|Categories
-----------------------------------------------
12	|UPS	|[Power].[Accessories].[Obsolete]

    I now denormalizing is not very correct but I need to do this due to integration/export.
    Does Access SQL has any capabilities to do this, since it is some sort of limited?
    If so, can anyone give me a tip?

    Thank you
    Last edited by RS_Arm; Dec 3rd, 2007 at 06:29 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width