Continuous form view: new record columns

[acrocker3434]

Hi-
Any suggestions on how to make a continuous form view with new records as columns instead of rows?


I have -

date: 1/1/2010
topic1: reviewed
topic2: competent
topic3: reviewed

date: 1/2/2010
topic1: reviewed
topic2: competent
topic3: reviewed

I want -

date: 1/1/2010 1/2/2010
topic1: reviewed reviewed
topic2: competent competent
topic3: reviewed reviewed

Thanks!

 

[vbaInet]

How do you intend it to be displayed if you had 1000+ records?

 

[PNGBill]

Apart from VBI's important point one way to manipulate data is to use Temporary Tables.
This may require a Macro to perform the query steps of Temp table and appending the Data.

Another option that may give the result is a CrossTab query.

Or, just rethink what you want to achieve and maybe a Form / Report with Unbound TextBox controls will give the result.