Search results

Thanks alot Friend, it works God bless you

Please find the Database sample attached

Well well, the YearDatemade is a calculted field from date of payment the SQL id like below: SELECT Payments.Pupilname, Payments.studentID, Payments.Class, Payments.Term, PaymentsT.Payno, PaymentsT.Itempaidfor, Payments.Amount, Payments.PayCode, PaymentsT.Schoolfees...

Thanks actually when i it in the querry its like this. TermFees: DSum("Amount","Payments","Class ='" & [Class] & "' AND Term ='" & [Term] & "' AND YearDatemade ='" & [YearDatemade] & "'") But it doesn't work

Hullo Friends , a trying to Sum up school fees payments in a query where by i need to add a given class school fees in a given term and year am trying to use the Dsum function, but am falling to make it This is what i have Class school fees school term school year...

Sure ! thanks Arnel

Thanks alot C.J London

So how should i approach it Thanks

Hullo Every on I would like you to help me find a solution , am trying to rank Positions of students marks Scores per term, the students are in different Classes so the positions must depend on their Classes Per term am using this Code but its Not working out Rank : DCount("Score...

ineed help Friends, I have a task am working on but something has failed to pass out

Hullo Every on , am new to the Forum, Its a pleasure to be here