Invoice Payments Query

[Sarma]

Yesterday, I posted the query. CJ_London has found out a solution; gave me the SQL required, to find out the dates on which invoices have been paid off. Here, he took a table as example, wrote the SQL and got the answer.

Today, I tried to carry out the same. Instead of a teble, my input is a query. I wrote the SQL. But it doesn't work. Shows error 3072.

Where did I make a mistake ?

I am attaching herewith the excel sheet that shows Working example and also the real file wherein SQL is not working.

I request help from the forum.

Rgds

Sarma

 

[pr2-eugin]

Sarma, What is the exact error you are getting? i.e the Error description?

Also could you post the code?

 

[Sarma]

I had attached the excel file. First sheet contains the first table, the code I wrote and the result. Second sheet shows my real problem, the code I wrote and the result. Result indicates error 3072 with description which I had shown in the same second sheet. Request you to see the same. If possible you can create a small Access file a and file b and see that file a works, but not file b.

 

[Sarma]

I had attached the excel file. First sheet contains the first table, the code I wrote and the result. Second sheet shows my real problem, the code I wrote and the result. Result indicates error 3072 with description which I had shown in the same second sheet. Request you to see the same. If possible you can create a small Access file a and file b and see that file a works, but not file b.

 

[Sarma]

Any body wishing to answer ? Thanks in advance.

 

[jdraw]

How about posting your code or database?

 

[Sarma]

jdraw: I have attached the excel file that shows working example.In this, I took an example, wrote the SQL and got the answer. But I have also shown the real file wherein I gave the input table, showed the SQL and also showed the error message I am getting. Request you to see the excel file which is attached with the question.

 

[JHB]

If the attached picture show the result you are after, then try to look at the different field type, because by me it runs ok.

 

[Sarma]

Result is what I am needing. But then, when I run the query in the real application, it shows error code 3072.

 

[JHB]

Have you checked the different field type?

If possible you can create a small Access file a and file b and see that file a works, but not file b.

By me file b works. Have you self tried to create a small Access database for file b?
If it not works then post the small Access database.

 

[Sarma]

I think that in the real file, the date field is appearing as date but it is having the property of text. I have converted text to date and this problem is solved. But I am having a different problem now which I need to solve. I think that the cumulative invoices and payments are also text fields and today I will attempt to convert them into number fields and attempt to run the sequel query.

 

[Sarma]

JHB: Thanks for the interest. I have re-worked out the earlier queries; avoiding problems like a date is not date as per property but it is a text; a number is appearing like number but internally it is text. Rewrote the SQL appropriately. It is now working perfectly. THANKS.

 

[JHB]

You're welcome - glad to help.