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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mhdragon17

  1. mhdragon17

    Problem with a SUM

    im not really aggregating the info like what ive read about a group by, im really trying to maintain each individual record, keeping the same number of rows, while also displaying the family balance as an additional column. If i'm doing something wrong, then let me know, but i would like just a...
  2. mhdragon17

    Problem with a SUM

    SELECT STD_DEMO_DISTRICT.ID_STD_DEMO_DISTRICT, FAM_STUDENT_FAMILY.ID_FAM_FAMILY_INFO, ParticipantAccount.Balance FROM STD_DEMO_DISTRICT INNER JOIN StudentPersonal ON STD_DEMO_DISTRICT.RefId = StudentPersonal.RefId INNER JOIN Participant ON StudentPersonal.RefId = Particiapnt.RefId INNER JOIN...
  3. mhdragon17

    Problem working with asterisks

    oh yeah ive tried to put them in brackets and that didnt work
  4. mhdragon17

    Problem working with asterisks

    this is more a visual studio question, but i figured someone would be able to answer it... what is wrong with this =IIF ( Fields!AttendanceCode.Value = "\*" OR Fields!AttendanceCode.Value = "P", "Normal", "Bold") Somebody decided to use an asterisk in the database to make it a little more...
  5. mhdragon17

    nested query problem

    Okay, I am beginning to program in t-sql and everything is going well except for one problem. I have status dates in one table, attendance dates in another table. The status dates are based on personalids, and all are in a table. i know to join on the id, but i need the most recent status date...
See more

Part and Inventory Search

Back
Top