Displaying records from left to right

[James]

I don't think you can use a continuous form to display records from left to
right, but correct me if I'm wrong.

What I'm trying to do is create a form which shows up to 6 years data side
by side, each record holds results for 1 year. So is there a way I can
display up to 6 records side by side on a form?

 

[KARL DEWEY]

Your query can have six calculated fields, each showing the data from
different years.

 

[James]

I'm not quite sure what you mean by calculated fields in a query, please
could you expand a bit.

Thanks

 

[KARL DEWEY]

If the following is your table structure --
SomeField
ActionDate
Amount

You can use calculated fields like this SQL statement --
SELECT SomeField, Sum(IIf(Format([ActionDate],"yyyy")=2005,[Amount],0)) AS
2005, Sum(IIf(Format([ActionDate],"yyyy")=2006,[Amount],0)) AS 2006
FROM [YourTable];