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!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
multiple wheres with dates please
I have the following table: POINTS ______ pid junior clubpoints countypoints junioropenpoints date I wish to show a sum for club, county and juniot points grouped by junior. This is fine but now I need to show, in the same table the sum of club county and junior open points before the first... -
-
join to populate two key field
this is probablt easy but i am stuck table1 UserID, Name, Pass 1 jam pas 2 and pas2 table2 Location, User1, User2 strat 1 2 birm 2 1 Thanks for any help User1 and User2 in tabele2 are supposed to relate to userID in table2. How do I set this up (is...
