Adding to Existing Reports and Querys

[keytone]

Ok guys, I'm a newbie and I'm sure what Im about to ask is fairly simple... but still yet I'm a newbie that need help and In a very short time frame, so all quick responses are greatly appreciated. With that being said... I have a report that was created before my being asked to take over, now that I've been asked to take over, the boss wants to add the following things to the existing report... another column labeled "OCAT Team". 2ndly, on this "OCAT Team" there are only 5 members, and I'm needing the names of those 5 members to populate in the "OCAT Team" column but only in the rows or fields associated with the OCAT Team, or the perspective members of the team. I hope that makes sense, I was confused trying to type it out. Please help asap, thank you all in advance. I've attached a screen print to further help with a visual... thanks!

 

[AccessMSSQL]

there seems to be a problem with your image. I can't view it.

 

[MarcieFess]

The jpg opened for me just fine but I'm sorry, I'm a newbie too and can't help you.

 

[pr2-eugin]

AccessMSSQL, here is the image.. I am not really great with reports.. If this is your expertise level please look into it..

 

[AccessMSSQL]

So is it possible, keytone, that you can post more information? How are the names being shown in the footer? Are they being populated from a field in the table or are those hard-coded on the report? Also, what is the logic in the database for an OCAT team member? You say you only want the team members to show up in the rows or fields associated with the team member? How is that stored in your tables? Can you maybe send a screenshot of the DESIGN view of the report.