Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: drelefun
  • Content: Threads
  • Order by date
  1. drelefun

    removing carriage return after table.

    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?
  2. drelefun

    Two table join query

    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...
  3. drelefun

    Group by issue

    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...
  4. drelefun

    two columns but only need to show one query help

    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...

Part and Inventory Search

Back
Top