Search results

Page size is A4 Report width is 11.125" Please guide me how to fix it.

I am using Parameter.

I have a report that runs a query that asks you to select the Start Date and End Date. The report runs correctly and presents the proper information. What I would like to do is to have the dates that I run the report for to appear in the header of the report. The following report is from...

Thank you very much to all of you. Its Done now! Special thanks to plog! :)

Usually we do the entry at the time of paying and receiving the amount. In some cases we do the entry before few days and some cases after few days. But VoucherID will always unique for each voucher we issue.

Thank you very much for your guidance. Can you tell me what should my statement? I Want Something Like this: But I am confused how to do it.

Now Its: SELECT bDebitVoucher.VoucherID, bDebitVoucher.PaymentDate, bDebitVoucher.AmountReceived, bDebitVoucher.AmountPaid, (Select Sum([AmountReceived]-[AmountPaid]) From DebitVoucher WHERE DebitVoucher.PaymentDate<=bDebitVoucher.PaymentDate) AS Balance FROM DebitVoucher AS bDebitVoucher ORDER...

Thank you I've correct it.

Ok dear no problem. Thank you so much June7

Hi plog thank you so much for your response. I've deleted space before FROM. No don't have Date field but I have PaymentDate field in DebitVoucher Table. Yes I want to use PaymentDate in WHERE. Now my SQL statement is: SELECT bDebitVoucher.VoucherID, bDebitVoucher.PaymentDate...

Thank you

When I am trying to save the following SQL Query an error is appearing please check the screenshot. SELECT bDebitVoucher.VoucherID, bDebitVoucher.PaymentDate, bDebitVoucher.AmountReceived, bDebitVoucher.AmountPaid, (Select Sum([AmountReceived]-[AmountPaid])From DebitVoucher WHERE...

Hi can you tell me what is "DataVoucher" in the above code?

Can you explain in detail?

Hello, Thank you very much.

Thank you

Thank you

Hi experts, I need your help regarding petty cash report. I've created a petty cash with debit and credit column, I want to add Balance column, also want to add previous balance field as well. I am sharing screenshots of a Sample Petty Cash Report (Created in Ms Excel), DebitVoucher Table...

Thank you

Thank you so much theDBguy