Whew. Relaxed :) You're very wellcome Neil. Table seems to be a good candidate for pivot table (and graph). If you think of it code is in a thread posted today (title something like "Page totals in excel").
Cetin
>That worked! Thank you thank you thank you Thank you!
>
>Neil
>
>
>
>>>Thanks,
>>>Neil Preston
>>Maybe first record has a spectacular touchdowns count :) Just kidding. Sorry couldn't resist.
>>As I could see at first glance main isthe linker to both tables. Then I would put main in middle :
>>
SELECT Reg_main.reg_year, Reg_main.last, Reg_main.first, Reg_main.city,;
>> Reg_main.st, Reg_fb.pos_num1, Reg_fb.pos_num2, Reg_fb.touchdowns,;
>> Reg_fb.rush_yds, Hs.hs_name, Hs.city, Hs.state;
>> FROM reg_fb INNER JOIN reg_main ;
>> ON Reg_main.registr_id = Reg_fb.registr_id ;
>> INNER JOIN hs ;
>> ON Reg_main.ceeb = Hs.ceeb ;
>> WHERE Reg_main.reg_year = '99';
>> ORDER BY Reg_main.last
Also I just separated the "On .." parts for they're easier to set correctly this way.
>>Cetin