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
I am still getting the result
Thanks a lot for your help. I am still getting the same result that is the costctr is repeating on every line instead of repeating once and then the category items connected with it coming up. Now I dont know what to do. Do you have any other ideas around the problem
All I want to do is to be able to click on a cost center number in a combo box and the corresponding categories associated with that cost center showing up in a text box or a combo box. I have no idea how to do that. I am a novice so bear with me.
KW