Search results

In the statement below, CCur(NZ([Party Payments].[Advance Bill Value],0) Are you telling it to come back as zero if the value is not set to currency? and do all of your fields have the same data type? No. What I need is the total of all values of "Advance Paid Gross" in all the stages i.e...

I will be greatful for the help. This is very urgent.

Anyone can help me out with this problem. Its urgent. Dont think otherwise.

Sir, I am attaching the same Excel File with modifications for clear understanding of the problem. The highlighted ones are the missing values which i am not able to get. I have created 5 Nos. Subforms for Data Entry Purpose which you can find in the attached file in order. The SQL Query is...

Sir, attached pls. find the Excel sheet where I have entered Bill details for 3 Invoices. I want to send the total Database to you but it is 48 MB in size. Pls. advise.

Attached word file in which i have given calculations for obtaining 'Advance Bill, 1st RA Bill, 2nd RA Bill, 3rd RA Bill, Pro rata Bill, Final Bill Payable' values. I dont know whether it is the right method of getting the result or not. pls. go thro and help me out. Is there any other way of...

Still i am not getting the result. Is there any other way of getting the result. Pls. help ASAP.

have created a database for Payments entry for various parties in which I have created a Select Query for obtaining the Bill Details (Advance, Running & Final Bills) such as Bill value, Advance Paid, Bill Accounted, TDS, WCT, Balance Payable. I have given calculations based on Bill...

But still I am not able to get the result. I want to attach the file for ur reference. where can i find the attachment tab. Pls. reply

I have created a query for "Party Payments" in which I have given formulas for obtaining Advance, 1st RA Bill, 2nd RA Bill, Pro-rata Bill, Final Bill Payable values. In which one calculation field called "Advance Paid Gross (Amount paid Upto Pro Rata Bill)" i ve given calculation like this...