I am working on making a calendar-like report. It has the weeks listed at the top of the report, and an X if an event falls on that week. I am writing code in Visual Basic to search through a query that I have to see if a value in the query is a week. I have everything up to this point. My question is:

I want to create a table that has name of the event and weeks 1-52. I want to populate this table with a loop. Is there a way to loop through the columns to see if they are equal to the value? So if the query has week 52 listed, the visual basic will get to a count of 52 in one loop and go to a statement that will look for 52 in the table, and put an X there. Any ideas?

I know its not crystal clear, so let me know if you want clarifications.