GrahamUK33
Registered User.
- Local time
- Today, 15:07
- Joined
- May 19, 2011
- Messages
- 58
What I have is report that lists all the project names, below there is a total of the projects and under that is a grand total number of all the records under every project.
What I am trying to achieve is having a total number of records for each project.
Table
tblProject – contains the projects
tblRecord – contains all the records
Relationship
tblProject[ID] with a one-to-many relationship to tblRecords[ProjectID]
The report is bound to tblProject
This field lists all the project names (WORKS)
Name: Project
Control Source: Project
This field gives the total number of records for each project (DON'T WORK)
Name: TotalProjectRecords
Control Source: =DCount("[Project]","tblRecord","[Project]='*'")
This field gives the total number of projects (WORKS)
Name: TotalProjects
Control Source: =Count([Project])
This field gives the total number of records in all projects (WORKS)
Name: TotalRecords
Control Source: =DCount("Project","tblRecord")
What I am trying to achieve is having a total number of records for each project.
Table
tblProject – contains the projects
tblRecord – contains all the records
Relationship
tblProject[ID] with a one-to-many relationship to tblRecords[ProjectID]
The report is bound to tblProject
This field lists all the project names (WORKS)
Name: Project
Control Source: Project
This field gives the total number of records for each project (DON'T WORK)
Name: TotalProjectRecords
Control Source: =DCount("[Project]","tblRecord","[Project]='*'")
This field gives the total number of projects (WORKS)
Name: TotalProjects
Control Source: =Count([Project])
This field gives the total number of records in all projects (WORKS)
Name: TotalRecords
Control Source: =DCount("Project","tblRecord")