Sola
12-28-2007, 10:14 AM
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?