Best way to display variable data on form

[svjensen]

I need to present data to my user on a form.
The data comes from the query:

TRANSFORM Sum(tblTable.Value) AS SumOfValue
SELECT tblTable.ExpenseType
FROM tblTable
GROUP BY tblTable.ExpenseType
PIVOT tblTable.Year;

The nature of the query means, that both the number of rows and columns are variable, as well as the column headers, which I also wish to display.

So far I have displayed the data using a listbox, but I am uncertain if this is the best way.
Which would be the best way to display this?

 

[MarkK]

One option is that instead of a form, you can directly load a query object into a subform control. To do this, set the SourceObject property of the subform control to something like "Query.NameOfYourQuery".
In this situation you don't need to know how many fields there are or what their names are.
HTH,