06-07-21, 02:46 PM
عدل الاستعلام ليتماشى مع معايرك اذا كان في البحث ضع :
PHP كود :
dim sqlstr0 ase string ="SELECT ClintTable.ClintName, Sum(ClintTable.Maden) AS Maden, Sum(ClintTable.Daeen) AS Daeen, (Sum(ClintTable.Maden)-Sum(ClintTable.Daeen)) AS Rased FROM ClintTable where ClintTable.ClintName='"& textbox1.text &"' GROUP BY ClintTable.ClintName;"
dim sqlstr1 ase string ="SELECT ClintTable.ClintName,ClintTable.BDate, Sum(ClintTable.Maden) AS Maden, Sum(ClintTable.Daeen) AS Daeen, (Sum(ClintTable.Maden)-Sum(ClintTable.Daeen)) AS Rased FROM ClintTable where ClintTable.ClintName='"& textbox1.text &"' GROUP BY ClintTable.ClintName,ClintTable.BDate;"
سبحان الله وبحمده سبحان الله العظيم و الحمد لله ولا اله الا الله والله اكبر