Displaying records from left to right

  • Thread starter Thread starter James
  • Start date Start date
J

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?
 
Your query can have six calculated fields, each showing the data from
different years.
 
I'm not quite sure what you mean by calculated fields in a query, please
could you expand a bit.

Thanks
 
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];
 
Back
Top