Grouping Query getting multiple rows in access with vb6

[sathyguy]

friends...

can anybody check this query and tell me where i am making mistake...i have to get a single row for each record...but i am getting mutiple rows...this is ms-access query with vb6 as front end.

"select [stdentry.sno],[stdentry.branch],[stdentry.stdname],[stdentry.amtobepaid]," _
& "iif([feesdetail.paytype]='DD',sum([feesdetail.paidamt]),0) as totpaid," _
& "iif([feesdetail.paytype]='CASH',sum([feesdetail.paidamt]),0) as totpaid1 " _
& "from stdentry,feesdetail where " _
& "([feesdetail.delstat]='N') and [stdentry.sno]=[feesdetail.sno] and [stdentry.refundstat]='N' " _
& "group by [stdentry.sno],[stdentry.branch],[stdentry.stdname],[stdentry.amtobepaid],[feesdetail.paytype]"

thanks and waiting for somebody's help.

[rpeare]

You're using 2 tables that I can see:

STDENTRY
FEESDETAIL

You are grouping on 5 fields

STDENTRY.SNO
STDENTRY.BRANCH
STDENTRY.STDNAME
STDENTRY.AMTOBEPAID
FEESDETAIL.PAYTYPE

One of these fields has multiple records per client, my guess is that it's your feesdetail table since I would guess that you only have one record per student in your STDENTRY table. So, look at your FEESDETAIL table and see if you do, in fact, have multiple paytypes. (I suspect you do since you're dealing with them differently in your query). If you only have 2 pay types DD or CASH you are already handling those in your query and you do not need to have the PAYTYPE in your query at all, you can remove that field from your query and from your GROUP BY statement.