grrrrrrrr

thanks so much for all your help, it turns out my sql was correct, however i did change it to your suggestion jeff. my problem lay in my grid...

yeah the total_cals_eaten on table 2 for each journal_id should be added up and put into the other table, i was thinking this would save look up time as this...