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