thanks for any help you give me on this Jeff (and the rest of you), you guys have been a great help.

1. well that wasnt much fun at all - I just posted this once and the post apparently didnt work.

Anyway here it is again.......

Question...

thats actually what I am looking into right now - I somewhat assumed that these indexes existed from those that built this structure

for the record it isnt homework at all.  I was having a hard time to get this information subtotaled in this way - and efficiently.  The suggestions here have at...

"Assuming Resum is the same as BookNum that appears in most of the tables:"

yes i apologize, ResNum should be the link to all tables marked as "book num"

thanks to both...