Posts

Showing posts from March 28, 2019

1982 Richmond Spiders football team

Image
1982 Richmond Spiders football team From Wikipedia, the free encyclopedia Jump to navigation Jump to search 1982 Richmond Spiders football Conference Independent 1982 record 0–10 Head coach Dal Shealy (3rd year) Home stadium City Stadium Seasons ← 1981 1983 → 1982 Division I-A independents football records v t e Conf     Overall Team W   L   T     W   L   T No. 1 Penn State   –   –       11 – 1 – 0 No. 13 Florida State   –   –       9 – 3 – 0 No. 10 Pittsburgh   –   –       9 – 3 – 0 No. 19 West Virginia   –   –       9 – 3 – 0 Boston College   –   –       8 – 3 – 1 Southwestern Louisiana   –   –       7 – 3 – 1 East Carolina   –   –       7 – 4 – 0 Miami   –   –       7 – 4 – 0 Southern Miss

Aluminium sulfate

Image
Aluminium sulfate Names IUPAC name Aluminium sulfate Other names Aluminum sulfate Aluminium sulphate Cake alum Filter alum Papermaker's alum Alunogenite aluminum salt (3:2) Identifiers CAS Number 10043-01-3   Y 7784-31-8 (octadecahydrate)   N 3D model (JSmol) Interactive image ChemSpider 23233   Y ECHA InfoCard 100.030.110 EC Number 233-135-0 E number E520 (acidity regulators, ...) PubChem CID 24850 RTECS number BD1700000 UNII I7T908772F   Y InChI InChI=1S/2Al.3H2O4S/c;;3*1-5(2,3)4/h;;3*(H2,1,2,3,4)/q2*+3;;;/p-6   Y Key: DIZPMCHEQGEION-UHFFFAOYSA-H   Y InChI=1/2Al.3H2O4S/c;;3*1-5(2,3)4/h;;3*(H2,1,2,3,4)/q2*+3;;;/p-6 Key: DIZPMCHEQGEION-CYFPFDDLAS SMILES [Al+3].[Al+3].[O-]S(=O)(=O)[O-].[O-]S([O-])(=O)=O.[O-]S([O-])(=O)=O Properties Chemical formula Al 2 (SO 4 ) 3 Molar mass 342.15 g/mol (anhydrous) 666.44 g/mol (octadecahydrate) Appearan

Sum by groups between 2 tables

Image
0 I, im trying to Sum by groups between 2 tables. Basically im trying to show only the Table 'Count' with each SUM() of Table 'MoneyMovements' group by 'Bank_code'. Is this possible?. I tryed with Left join (including the 'MoneyMovements'in 'Count'). but i dont understand how to separe the sum... Any suggestion?. Im using ACCESS 2007 in VB.NET Table 'Count' +----+--------------+ |Code|Bank | +----+--------------+ |1 |MACRO | +----+--------------+ |2 |Santender Rio | +----+--------------+ |3 |Galicia | +----+--------------+ Table 'MoneyMovements' +-----+--------------+ |Money|Bank_code | +-----+--------------+ |200 |1 | +-----+--------------+ |300 |1 | +-----+--------------+ |0