Report Question

[Guest]

I'm trying to create a report that will have 3 levels: Entry, Job and Parts.
Specifically, a job consists of many parts and an entry of many jobs. what I
want to do is to make all these data appear in a single form and later on a
report, displaying also a sum for the parts cost of each job and a total for
all the job costs (sum of all the parts used in all jobs). Is such a thing
possible in MS Access?

 

[Wolfgang Kais]

Hello kourkoutas.

I'm trying to create a report that will have 3 levels: Entry, Job
and Parts. Specifically, a job consists of many parts and an entry
of many jobs. what I want to do is to make all these data appear
in a single form and later on a report, displaying also a sum for
the parts cost of each job and a total for all the job costs (sum
of all the parts used in all jobs). Is such a thing possible in MS
Access?

Yes.

An Entry form can have a subform for jobs and the job subform can have
a subform for parts. In a report, you can even use groupings to display
the 3 levels. On every grouping level, you can display a sum. The info
bout parts would appear in the details section. A footer for jobs could
contain a sum per job and the footer for the entry group could contain
a sum over all jobs of that entry (same formula). The same formula,
placed in the report footer, sums up over all entries in the report.