K
kctss
1. I have a hand me down DB with MDE's and I'm trying to recreate the source
code for future development.
2. Configuration: Two tables with a one to many relationship. Table 1
contains Project info; such as Type of project (A-Z), Date started, and
Forecasted Hours to completion. Table 2 (many side) contains work logged
against that project, such as Date work performed, and number of hours
against the project(actual work).
Normally there are 12 constant projects, however there may be multiple
projects of a certain Type as something makes them unique within that Type.
3. Goal: Produce a report that summarizes the work against all projects and
compare actual work to the forecasted work for a particular month.
So if there are 3 A-Type projects, 1 B-Type, and 12 C-Types the report
should show:
Type A Forecasted Hours: 345 Actual Hours for August: 134
Type B Forecasted Hours: 22 Actual Hours for August: 8
Type C Forecasted Hours: 212 Acutal Hours for August: 333
4. I can successfully do a subquery for the records needed based on the Date
field on the MANY side and then join to the one side based on the key. Using
one report, the totals on the many side work fine, but the I can't get the
Forecasted Hours on the one side to total correctly. Many hours no success. I
tried using a Sub report for the many side and that appears to be close to
what I need.
5. Apparently I don't have a good understanding of queries, reports,
subreports, etc but it doesn't feel like it should be this difficult to do.
6. Suggestions, insight would be appreciated.
Thanks
code for future development.
2. Configuration: Two tables with a one to many relationship. Table 1
contains Project info; such as Type of project (A-Z), Date started, and
Forecasted Hours to completion. Table 2 (many side) contains work logged
against that project, such as Date work performed, and number of hours
against the project(actual work).
Normally there are 12 constant projects, however there may be multiple
projects of a certain Type as something makes them unique within that Type.
3. Goal: Produce a report that summarizes the work against all projects and
compare actual work to the forecasted work for a particular month.
So if there are 3 A-Type projects, 1 B-Type, and 12 C-Types the report
should show:
Type A Forecasted Hours: 345 Actual Hours for August: 134
Type B Forecasted Hours: 22 Actual Hours for August: 8
Type C Forecasted Hours: 212 Acutal Hours for August: 333
4. I can successfully do a subquery for the records needed based on the Date
field on the MANY side and then join to the one side based on the key. Using
one report, the totals on the many side work fine, but the I can't get the
Forecasted Hours on the one side to total correctly. Many hours no success. I
tried using a Sub report for the many side and that appears to be close to
what I need.
5. Apparently I don't have a good understanding of queries, reports,
subreports, etc but it doesn't feel like it should be this difficult to do.
6. Suggestions, insight would be appreciated.
Thanks