K
Ken
I am running MS Access 2000. I have a real estate table
that has a large number of records of real estate
properties. In a separate table, linked to the REProperty
table, is the financial operating statement data for each
quarter for each particular property.
My goal is to create a form that lists the oldest record
data in the first column on first column and the next
period in the column to its right and so on. I want it to
only look back four quarters.
It would look like this:
2002 2002 2003 2003
Description Qtr 3 Qtr 2 Qtr 1 Qtr 2
Gross Income 100,000 110,000 115,000 120,000
Vacancy 10,000 12,000 14,000 16,000
and so on........
I don't know how to write code, so I was trying to figure
this out either using expressions in the query or placing
expressions on the form itself. Since the year is input
and the quarter, I came up with a time factor that is
TimeFactor:[Year] + ([Qtr]*.25) which can help with doing
queries to order the data.
I guess I am trying to be creative within what I know. I
know someone out there has done this before. The hard
part is communicating it to me outside of writing code.
Any ideas would be appreciated. Thanks in advance.
Ken
that has a large number of records of real estate
properties. In a separate table, linked to the REProperty
table, is the financial operating statement data for each
quarter for each particular property.
My goal is to create a form that lists the oldest record
data in the first column on first column and the next
period in the column to its right and so on. I want it to
only look back four quarters.
It would look like this:
2002 2002 2003 2003
Description Qtr 3 Qtr 2 Qtr 1 Qtr 2
Gross Income 100,000 110,000 115,000 120,000
Vacancy 10,000 12,000 14,000 16,000
and so on........
I don't know how to write code, so I was trying to figure
this out either using expressions in the query or placing
expressions on the form itself. Since the year is input
and the quarter, I came up with a time factor that is
TimeFactor:[Year] + ([Qtr]*.25) which can help with doing
queries to order the data.
I guess I am trying to be creative within what I know. I
know someone out there has done this before. The hard
part is communicating it to me outside of writing code.
Any ideas would be appreciated. Thanks in advance.
Ken