Search results

I am using this formula but there is an error like #ERROR =DSum("[qty]","Ledger Q","Transaction Date< [forms]![Ledger Date Frm]![txtdatefrom] AND Lastname='" & [Lastname] & "'") I think My formula is wrong. can u help me?

How to use different joined table paths in d sum formula?

Please Help Me How to Use Query path instead of Table Path in a Dsum Formulla? For Instance I have a Field Named (Qty) in a table Named (Transaction) Now The Dsum Formula is =DSum("[qty]","transaction","xdate<forms!frmledger!stdate") But i want to Use Query instead of table For instance I...

Morning Sir Today i have an other problem. Is it possible that we can hide a field in ms access report if another field is Null or 0 For instance i want to hide (xyz) field if (abc) field is null or zero. Wasim Shahzad

Thank You So much Sir For your cooperation

i have uploaded my sample database in which i want to get result category wise. Plz help me.

but sir i want to get filtered opening balance for a specific category. is it possible?

thanks alot for wishing my birthday.

i have replaced it but there is nothing to show in that feild. can u send me the sample database again after changing.

HI khawar thank u so much to solve my problem there is another question that can i use the Query instead of a table in d sum formula(in your sample database) you have sent me.

Thank you so much khawar you really solve my big problem but now i have another problem than can i use a query path instead of table name in your dsum formula for accumulated balance?

Thanks Khawar you have send me the sample database but in that sample you have made a query in SQL but i don't know about SQL. So if you can send me that sample in simple access query then i will be very thankful to you. Dj Wasim :)

Hello All I am a new user and having problem in ms access report. How can i get the ledger of some account in ms access report for a specific period with previous closing balance. For Example For Example here is an whole Month ledger i.e Date Qty Rate Amount Balance...

Hi Every Body.