Search results

83 Experts have seen the question so far; but no reply. Is it a very difficult question ?

I have this Access query that has the following fields: Pair: These are various forex pairs like AUD/CAD, AUD/CHF, etc, etc..totally 54 pairs. Value: This is a field that contains values of the forex on a 0-100 scale. This is on an ascending scale, starting from 1 and going till 100; for...

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.

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...

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

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...

Any body wishing to answer ? Thanks in advance.

I have this 2013 version of MS Office with Access. I am fond of Access in which I have developed many applications with my limited knowledge. I want to learn this thoroughly before I embark on other database softwares. In fact, I want to learn Excel also deeply because there are several features...

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...

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...

How do I become a scholar in MS Access ? Where do I get A-Z training in MS Access ? I have 5-10% knowledge which I need to take it to 100%. Any books ? Institutions ? Microsoft university ?

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...

Wow. Brilliant. Grateful. Worked like a charm.

CJ: Better still is if we can have the word 'Not Applicable' when invoice value = 0

CJ: I have tried out. It works. Just a small suggestion. Can it avoid 'Not Paid' in the row where invoice value =0 ? Grateful to your help.

Your both assumptions are right. Can you please try out the example given later ?

Please use this example. Reject the earlier one. Rgds.

Galaxiom / Brainwarnock: Even date field would have achieved the same result. There was a small mistake I did. In the query design mode, I should have put Group By - Expression which works. Thanks.

Attached. Hope it reaches.

I have done what you wanted me to. Hope you will now get my file.