karmaimages
Registered User.
- Local time
- Today, 13:59
- Joined
- Nov 19, 2009
- Messages
- 15
Hi,
I have a form where I want to show some statistics from the database like count how many bits of outstanding work there are for a certain department.
I have a table called work_items - With various fields one being "Department" - I want on the form to display in a text box the number of times say "Sales" is selected as the department from the combo box.
So table is - work_items
Field - Department
Criteria to count - "Sales"
I can't seem to get a dcount to work, any help appreciated.
I have a form where I want to show some statistics from the database like count how many bits of outstanding work there are for a certain department.
I have a table called work_items - With various fields one being "Department" - I want on the form to display in a text box the number of times say "Sales" is selected as the department from the combo box.
So table is - work_items
Field - Department
Criteria to count - "Sales"
I can't seem to get a dcount to work, any help appreciated.