Sola
Registered User.
- Local time
- Today, 13:35
- Joined
- Jun 1, 2007
- Messages
- 14
Hi, all. I have a query that pulls together department names and the # of calls they placed. Due to the way the network tables were made, I often end up with two results for the same dept, like this:
dept_whatever 25
dept_whatever2 5
The second entry is identical to the first except that there is a "2" at the end. So it seems like I should be able to use VB in a form or report to add the two results together. Can someone give me a pointer as to what method I should be trying to use?
dept_whatever 25
dept_whatever2 5
The second entry is identical to the first except that there is a "2" at the end. So it seems like I should be able to use VB in a form or report to add the two results together. Can someone give me a pointer as to what method I should be trying to use?