Report with Unique Fields as Columns

[carcement]

I have a large query that has information from accounts sorted by date, account repeat but they are always associated with a different date. I'd like to create a report where each date has it's own column with an associated field displayed as the information in the column. However, as data is added to the table I'd prefer to do it without having to make a query to filter each date each time information is added.

The information is added in bulk with all the same dates, so ALL accounts (excluding newly opened accounts that may have no information with a certain date) should have information for each date - there will not be single accounts with their own date.

For example: An account numbered 12345 with data of 57% on 1/2/13, 63% on 6/2/13, and 89% on 12/2/13.

I'd like each of the dates to have their own column, with the account numbers as the row and the percent data to show under the date they are associated with.



I'm not quite sure how to manage this in a report, or if it is possible. Any help would be greatly appreciated, thank you.


Edit: base query column format is account #, date, then data point.

[June7]

You describe a CROSSTAB query. Building a perpetual report based on CROSSTAB can be difficult, especially with date field as the column parameter.

Review: http://allenbrowne.com/ser-67.html#ColHead