-
Query - how would u go about this
I have a table that looks like this:
Name of table: CategoryTab
Fields in tabe: 2
Fieldnames: Costctr and Category
The data in the table looks like this:
200500 Office
200500 Meetings
200500 Agency
200500 Revenue Offset
200502 Meetings
200502 Office
200502 Agency
200502 Travel
My problem is I want a query on a combo box that will list the costctr once and list all categories associated with that cost center.I want it to look like this.
200500 Office
Meetings
Agency
Revenue Offset
200502 Meetings
Office
Agency
Travel
Can someone help!
Thank You!
Kwahuboy
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
|
|