VB in Access 97 - Combining Two Results

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?
 

Users who are viewing this thread

Back
Top Bottom