Formatting a report

  • Thread starter Thread starter Tracy
  • Start date Start date
T

Tracy

I am using Access 2002.

I have created a database with student award
information. The following fields are in each student
record:
SourceAccount1 $Amount1 Term1
SourceAccount2 $Amount2 Term2
SourceAccount3 $Amount3 Term3

The term field has five options: Academic Year, Fall,
Spring, Summer, or Winter.

I would like to create a report formatted as follows with
the values for each applicable term being the
corresponding $Amount for each Account:

---------------------TERMS---------------------
Academic Year * Fall * Spring * Summer * Winter
Account1
Account2
Account3


For example, if StudentA receives $427 from account1 6789
for Fall and $10,000 from account2 4367 for for the
Academic Year the report should look like:

----------------------TERMS----------------------
Academic Year * Fall * Spring * Summer * Winter
6789 $427
4367 $10,000
BLANK

Does anyone know whether or not this is doable? Thanks.
 
Tracy,
You can definitely do this. You would create your
detail line with 1 text box created for source account,
and 5 unbound text boxes for the amounts.
There would be an expression in each of the 5 text
boxes - something like this:

txtbox1=iif(term = "Fall", [$Amount],"")
txtbox2=iif(term = "Spring",[$amount],"")

Hope this helps.
 
Thank you. I will try it!
-----Original Message-----
Tracy,
You can definitely do this. You would create your
detail line with 1 text box created for source account,
and 5 unbound text boxes for the amounts.
There would be an expression in each of the 5 text
boxes - something like this:

txtbox1=iif(term = "Fall", [$Amount],"")
txtbox2=iif(term = "Spring",[$amount],"")

Hope this helps.
-----Original Message-----
I am using Access 2002.

I have created a database with student award
information. The following fields are in each student
record:
SourceAccount1 $Amount1 Term1
SourceAccount2 $Amount2 Term2
SourceAccount3 $Amount3 Term3

The term field has five options: Academic Year, Fall,
Spring, Summer, or Winter.

I would like to create a report formatted as follows with
the values for each applicable term being the
corresponding $Amount for each Account:

---------------------TERMS-------------------- -
Academic Year * Fall * Spring * Summer * Winter
Account1
Account2
Account3


For example, if StudentA receives $427 from account1 6789
for Fall and $10,000 from account2 4367 for for the
Academic Year the report should look like:

----------------------TERMS-------------------- --
Academic Year * Fall * Spring * Summer * Winter
6789 $427
4367 $10,000
BLANK

Does anyone know whether or not this is doable? Thanks.
.
Click to expand...
.
Click to expand...
 
Back
Top