Search results

Appl_DateInvDueDatePaymtCum_InvCum_PaymtPayment Date12-10-10264,33240,5080264,332014-12-1013-10-1028,50240,5090292,834014-12-1014-10-1044,01640,5100336,850014-12-1017-10-1055,19140,5130392,041014-12-1020-10-1071,25540,5160463,296014-12-1021-10-1043,57540,5170506,8710...

On a single day, there may be 2 or three invoices. Hence, I have summed them as Invoice amount. This amount has to be paid off after 45 days. That is why the invoice date is there and also the due date. Against this invoice due date, I need to find when it was paid off. This is the day when for...

When I wrote, it appeared normal but the data got mixed up because I copy / pasted two excel tables. I do not know how to attach them. The query gave me result with the following fields: Date Invoice Amount Due date of invoicee Amount Cumulative invoice amount Cumulative Payments received...

I have an Access application wherein date-wise invoices, payments are listed along with cumulative data. I need to find out the date on which each invoice has beeen paid off. My Access query result looks as under...

Thanks, Galaxiom! I have dates & invoices. I needed cumulative invoice value against each date. However, when I made the usual command, I am not getting the answer. What I did now is, I converted date into a number and then built the query for cumulative invoices. It worked very well. Grateful.

I have a query the result of which provides me a date field in the format 12-Oct-2010. I want that this field data to be converted to corresponding numbers such as 40463. I seek your help. Regards. Sarma

Please switch over to plant-based food; 24/7/365.

Thanks, Brian. But the expression did not work. Is there any syntax error ?

I have this Access file with Tables & Queries. I want selected queries to appear in RED colour and if possible BOLD too. Possible ?

I have a field in an MS Acess query that has records like - 1,000; 534; 769.13; 0; 654; 0, etc. It can also have few null records. I want to calculate the average of all records which are greater than zero. Ignore zero values or null values. Appreciate your help.

I have used the following SQL and was able to obtain result: SELECT Table1.[Serial No], Table1.Month, Table1.Amount, Sum(Format(DSum("Amount","Table1","[Serial No]<=" & [Serial No] & ""),"0,000.00")) AS RunTot FROM Table1 GROUP BY Table1.[Serial No], Table1.Month, Table1.Amount ORDER BY...

Plog: I used the following code & did not get it OK. SELECT [Table2].Number, [Table2].Invoice_Value, DSum("[Invoice_Value]","[Table2]","Number<=" & [Number]) AS RunningTot FROM [Table2]; What is this 'Number' you have written ?

Plog: I am very grateful to you for the answer. I will try it out tomorrow as it is 01.13 am here in Dubai. Rgds.

Sketchin: Thanks for your interest & advice. Possible to give the exact syntax instead of generic words such as 'variable' ? I am a perennial learner. My basic job is petroleum engg. Rgds

I have tried to run a query. I added a new field with DSUM("Amount","Table 1"). Result is that against each row, I got the same cumulative sum value whereas I need the cumulative value for each row. Trust I am able to clarify. Rgds.

I have an Access query that shows that the following invoices are to be paid off: Number / Amount 1 / 250 2 / 100 3 / 400 4 / 200 5 / 325 In another query, I have data of Amount received as 1,000. Now I want this amount to be assigned against each of the invoices such that the...

I have a result of a query that looks as under: Serial Number / Month / Amount 1 / Jan / 145 2 / Feb / 0 3 / Mar / 250 4 / Apr / 500 5 / May / 225 I have to make another query from this query that shows the results as under: Serial Number / Month / Amount / Cum. Amount 1 / Jan / 145 /...

I have solved the issue differently. I noticed that when I wanted a list of products meeting two specifications, the query gave me product meeting one specification and two specifications. I don't need the product meeting one specification as I want my product to meet both the specifications...

Thanks a lot. Learnt something today.

Ha. I said I needed intersection. But what I need is not Intersection. I think I must look at Unmatched Items wizard.