Datasheet Structure

[F1stman]

Hey Everyone,
First of all, does anyone know of a good resources online (besided MS pages)
with good access reports info or tutorials? If you could post a link that
would be great. Now the REAL question:
I have created a financial tracking database and now I have gotten creating
an exhibit using my data. My database is composed of three primary tables set
up like so:
Project Table(Including Project Fund Source Codes)--->Allocation
Table(Related to PFS Codes)--->Allocation Ledger(Related to Allocation Unique
ID)
This is a simplified version but it serves my purpose here. I am trying to
create an exhibit, preferably a report but I could use a form, that will
divide up the data like so with a list of allocations on the left and PFS
Codes on top, placing the amount under the appropriate PFS Code and obviously
on the row with the correct allocation:
____________________________________________________________________
General Project Information...
____________________________________________________________________
PFS 1 PFS 2 PFS 3
PFS 4
Allocation 1 $$$
Allocation 2 $$$
Allocation 3 $$$$
Allocation 4 $$$

 

[strive4peace]

Hi,

you can use the same subreport multiple times to report the
columns of information

make calculated controls on the report for linking the columns:

Name --> PFS1
ControlSource --> ="PFS 1"

Name --> PFS2
ControlSource --> ="PFS 2"

etc

Depending on how the labels on the left column are stored,
you can render those using the detail section and then put
the same subreport (so it will be used multiple times --
have the same ControlSource but a different Name) in each
"cell" under the PFS columns

LinkMasterFields --> AllocationID, PFS1 (or PFS2, etc)
LinkChildFields --> AllocationID, PFS

as for calculating totals... in the code behind the report:

'dimension global variables at the top:
DIM gPFS1total as currency, gPFS2total as currency, etc

'initialize variables on the ReportHeader format event:
gPFS1total = 0
gPFS2total = 0
etc

'use the detail Format event to add things up
if me.PFS1.subreport.HasData then
gPFS1total = gPFS1total _
+ me.PFS1.subreport.controlname
end if

'use the ReportFooter event to write totals
me.PFS1total = gPFS1total
me.PFS2total = gPFS2total
etc

Warm Regards,
Crystal
MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day

 

[F1stman]

Thank you so much Crystal. You've put me on the right track. Have a wonderful
day. Adam

 

[strive4peace]

you're welcome, Adam happy to help

Warm Regards,
Crystal
MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day