consolidation of same records into one count

[julius1]

I have 3 fields called A-CLLI, Z-CLLI and vacants. I have them grouped and am counting the number of vacancies, is there a way to get all of the matching A's and Z's to be grouped into 1 count of vacants?
say for example:
under A-CLLI I have with multiple entries:
BASNMOU0030
Under Z-CLLI I have with multiple entires:
BASNMOXAK03
Each line has various counts of vacancy. Is there a way to get a sum of all counts of vacancies between these 2 points?
I have tried grouping them, but still each count appears.
I currently get displays like this:
BASNMOU0030 BASNMOXAK03 9
BASNMOU0030 BASNMOXAK03 7
BASNMOU0030 BASNMOXAK03 4
I am trying to get the following instead:
BASNMOU0030 BASNMOXAK03 20
I am not sure what I am missing???? can any one offer any suggestions? Thanks for your time.

 

[GHolden]

Hi,

Can you post the SQL that you are using?



There are two ways to write error-free programs; only the third one works.

 

[julius1]

I just got it to work, it was simple enough which is way I couldnt see it.
I made one more query and just imported the CLLI's and did a sum of count of vacants. Worked like a charm.