Get Varying Query Columns into Report

[Elios]

Hello all, this is my first post - I've been googling everywhere for a solution. Thanks in advance for any help anyone may have...



I have a query that returns monthly metrics for the past 6 months. The columns look like this:

|item id| item info...| 1/2011 | 2/2011 | and so on...|

The report I want to create will have all the columns from this query. I want to put it into a report so i can show groupings such as "item category". The problem comes when I use the Report wizard and I add all the columns over. The month columns are not always the same. If I run the query today it will show months 11/2010 to 4/2011 but if I run the query in July it will show 1/2011 to 6/2011.

Is there a way that I can design a report to simply include every column from a query?

[June7]

Simple answer is No. However, VBA code can change control properties (ControlSource, Caption). I have done this to change Caption on report but not ControlSource. I have changed ControlSource on forms. The code would be in the Detail_Format event.