Search results for query: *

yep there's a carriage return in the source but i can't get rid of it. its the same one as when you open a new document

forgot to add i'm using word 2007

hi i've got a table that uses mail merge to populate it. however there is a carriage return that shows up between rows in the table and i can't get rid of it. any suggestions?

sorry i just meant really for 2 mel 1 4 3 2 mel 2 2 0 2 mel 3 0 2 2 mel 4 3 3 as its based on it being the aflgame_id = 2 and team_id = mel

i tried your tip ryan but it wasn't what i was after. here is some data from the table aflplayerstats Aflgame_id Team_id Player_id kicks handballs 2 mel 58 12 6 2 mel 358 2 3 2 mel 359 5 14 2 mel 360 8 6 2 mel 362 6 12 2 mel 364 7 7 2 mel 366 4 5 2 mel 370 9 9 2 mel 372 7 14 and aflscore...

i tried it and it still doesn't work. i'll try some different joins and see how that goes.

it just seems to get the wrong results and i'm not sure why. separately the results are right SELECT team_id, SUM(goals + behinds) AS 'Scoring Shots' FROM AFLScore GROUP BY team_id and SELECT team_id, SUM(kicks + handballs) AS 'Disposals' FROM AFLPlayerStats GROUP BY team_id but the results...

Hi I have two tables which i am trying to get data from. The two tables are AFLPlayerStats( aflgame_id(pk), team_id(pk), player_id(pk), kicks, handballs. goals, behinds, hitouts, tackles) and AFLScore(aflgame_id, team_id(pk), quarter(pk), goals, behinds) What I want to do is...

lol. cheers mate

wow. i didn't expect it to be so complicated. may i ask why this is required?

the scores are not recorded cumulatively. its the former. an example of a game is below aflgame_id team_id quarter goals behinds 2 mel 1 4 3 2 mel 2 2 0 2 mel 3 0 2 2 mel 4 3 3 2 stk 1 2 7 2 stk 2 5 0 2 stk 3 4 5 2 stk 4 2 3

is the reason why we have INNER JOIN AFLScore as awayscore ON awayscore.aflgame_id = AFLGame.aflgame_id AND awayscore.team_id = AFLGame.away and INNER JOIN Team AS away ON away.team_id = AFLGame.away is because the primary key for the AFLScore table is...

I’m trying to get the total score for a home and away team but not sure how to. Basically the way to get the score is goals x 6 + behinds. This only gets that quarter’s score and I want to group it by the team and game to get total score. I’m also not sure how to differentiate the team in this...

Well i’ve got the two tables data below. The two tables combined would give the result from my previous post. As you can see there is a home and away column but say i’m making the results page for fremantle i want to see the opposition column from my statement produce Richmond, @Sydney...

I’m trying to create a sports website to show sports results namely aussie rules football. I want to write a stored procedure to create the results for a separate team results against its opponents for the season. Essentially i have 2 tables Game: game_id, date, home, away Score: game_id...