Search results

Thank you,but I don't have a time stamp,And one thing I noticed is each month query gives different number of records,like the month of February 2015 return 713,month of June return 652 while month of may return 681 records instead of them returning 1079 records.

Good day,Please am waiting for your kind response to my SQL statement.

select m.id,m.surname, m.firstname,m.middlename,Nz([c.contributions],0) as Contributions,Nz([l.loanrepayment],0) as loanrepayment ,Nz([I.item],0) as items,m.banks,accountno,c.Date,i.Date,l.Date,c.Detail,I.Detail,l.[Detail Transactions] from ((membership as m left join contributions as c on...

My Query is not returning all my records am expecting 1079 records shown but am only seeing 656 records; I have 3 left table joins but wen I use date to filter I have some of my records missing. Please what may be the problem.

Good day Community, am happy to be a member,a Nigerian and has passion for building databse.:D