MSAccess Reports (VB?) Question

Hey gang-

I have a question with regards to customizing an Access 97 Report. I suppose 2000+ solutions might be relevant as well, just as long as I can get some help with the logic for this solution.

This report pools data from 2 tables using a one-to-many relationship. The number header section the report shows 4 columns of data for each instance in the 'Intersection' table (ie: Official Index Number (key), Location Abbreviation, Street Name, City). The detail section of the report grabs from the 'Cut' table (Official Index Number (which serves as the join of the two tables) and Intersection Letter).

Basically, I have some empty text boxes in the number header section that need to be filled depending on data coming from the detail section. INSTANCE EXAMPLE: Official Index Number: 1, Location Abbreviation: REF, Street Name: South Dock Rd., City Houston). The Detail Section (which is linked via Official index Number as 1) shows A on one line, then B on the next. Basically for each and every time through the query, I want Access/VB to put an X in a certain field if A is present in the detail section. And an X in another field if B is present, and so on.

Perhaps a simpler way to put it is "How can I have my detail txt field affect a txt field in the number header section above it?"

If i need to be more clear or try to show a shot, let me know.
Thanks!
-matt

bump