Ms Access 2013 Database -


i have create database in table name approved_schedule has column name fileno, stdname, amount1, amount2, , want add amount column in query process have written query.

for example: fileno = 7100, amount1 = 19430 , aoumnt2 = 0;

select sum(amount1 + amount2) 'total payment' approved_schedule  fileno = 7100; 

but query result total payment = 0;

what should do?

you need group if you're doing sum.

group fileno 

Comments

Popular posts from this blog

account - Script error login visual studio DefaultLogin_PCore.js -

xcode - CocoaPod Storyboard error: -