Bruce,I'm sure that would work but I couldn't get it to with my limited knowledge. However after poking around, I did get an if statement to calculate each table for me and then I used sum to add each to get to my total count. Probably the long way around but it works. Here's my next question if ...