Justin.ITPro
Registered User.
- Local time
- Today, 14:54
- Joined
- May 23, 2013
- Messages
- 10
I have created a report based off of a crosstab query. It is counting the number of instances that each group does a certain task and displaying the totals in the report.
On one of the reports it has to also include the budget for each group. I was able to include this by using a DLookUp toward the table and tying it back to the Groups displayed on the report. However my issue is not being able to now sum this column of information. What can I do to fix this?
I have tried SUM(DLookUp("CBudget","[Contract Budget]","[CommunityGroup] = '" & [txtCommunityGroup] & "'") and DSUM("CBudget","[Contract Budget]","[CommunityGroup] = '" & [txtCommunityGroup] & "'"), but neither work.
On one of the reports it has to also include the budget for each group. I was able to include this by using a DLookUp toward the table and tying it back to the Groups displayed on the report. However my issue is not being able to now sum this column of information. What can I do to fix this?
I have tried SUM(DLookUp("CBudget","[Contract Budget]","[CommunityGroup] = '" & [txtCommunityGroup] & "'") and DSUM("CBudget","[Contract Budget]","[CommunityGroup] = '" & [txtCommunityGroup] & "'"), but neither work.
Last edited:
