Search results

You may know it, but if you don't : If you use ChatGPT, you can create custom versions of ChatGPT that combine instructions, extra knowledge, and any combination of skills in a specific purpose. Each of them are called GPT and each GPT is a specialized ChatGPT made for a specific course...

Million thanks for all your efforts. I'm at home and don't have Access here. I'll check it on Monday. I really appreciate your assist.

It seems your situation is very different from ours. Here, there is a lot of effort to reduce car accidents. For example, people who have a gold driver’s license (5 years with no accidents) pay less for var insurance, less for fuel (per liter) or oil, pay lower taxes when renewing their driver’s...

I really appreciate this test. Since the table will grow soon, I think I will go with #2 sql. Million thanks for your time and help, and sorry for the confusion I caused.

It's fine. But the question is how much it effects on the payment. As I explained above, here, a full Non-Fleet Grade (20 years without accident) has a %60 discount. And it's huge. %10 for gold license. 5% for 35+ age and so on. I think you may want to check how your 40 years no accident effects...

You may have missed my edited reply. @CJ_London found the problem and I corrected #1. Access makes it hard to share databases when different locals are set in control panel, or when a database is written in an Asian language. I have had this problem frequently when others can not open my...

Maybe because of 28 years no ticket, no accident. Here, it's the main effect on insurance payments.

Good catch. Thanks. Yes, you are correct. The date I showed in #1 for 10 was wrong. I corrected it. I wasn't able to paste the table. It kept giving me ooops error and asked me to reduce my post to less than 10,000 characters. That was why I had to insert a table, and copy paste each field for...

I need only one record for each quantity. Edited post : I had pasted the wrong date for quantity 10. That was why you were receiving 2 records for 10. @CJ_London found the problem in #1. Sorry for the confusion, but the forum doesn't allow to paste a table. Thanks again for your help.

I had thought of that, but since the query was simple, there can't be any difference. I have far more complicated queies running on very large tables and the peformance is really fast. I'll try a passthrough with given top 1 solution to see how the result would be. But it won't be until Monday...

Just as a follow up : I don't know how car insurance works there, but here, normally the car is insured. It means that no matter who the driver is, the insurance can be used. But, we also have the option to select to apply for personal insurance. In this case, the person is insured and can drive...

Since you explicitly asked about insurance in other countries, here is my car insurance as an example. I live in Japan. I pay US $380 per year for my car. (Each year without accidents, makes it cheaper) To be able to compare with your situation, last year my annual income was a little more than...

I just tested your version. The result is correct, But it seems yo be very slower than the joined sql in #2. The #2 sql is instantaneous, but running your sql, takes around 1 to 2 seconds. First there's a blink then the result shows. If I chnge the where clause to AND p.PricesProductFK IN...

I just rechecked. The sql of #2 seems to show the correct result. Thanks.

The result data shown in my first post, was a copy and paste from the data sheet view of sql from #2. It shows only 7 records and it seems the result is correct. But I may be wrong though. I did lot of testing and may have pasted the wrong sql. I'm away from my PC and will try to start a remote...

After several trials and errors, the following seems to work. But honestly, I'm not sure if it can be relied on. There seems to be too many joins: I appreciate if you can correct this one, or suggest something to be used instead. Thanks. SELECT q.PricesOrderedFromFK, q.PricesQuantity...

I'm sorry for the length of the question. I don't know how I can explain it shorter. This is a working sql: SELECT PricesOrderedFromFK, PricesQuantity, Max(PricesRegisteredOn) As RegisteredOn, PricesRegisteredBy FROM tblProductPrices WHERE PricesProductFK = 34086 Group BY...

What's wrong with sharing an un-finished product? Others can help you finish it sooner. Your first post starts with: But you’re not sharing anything that can actually be tested. Instead, you keep giving lengthy explanations of how the product will work, and so far—if I’m not mistaken—nobody...

China’s economy does not rely on personal taxes the way most Western countries do. China’s government revenue depends on: 1-Corporate taxes. Companies that are owned and controlled by the government (SOEs) pay profits and taxes. Large private companies contribute significant tax revenue too...

To prevent this thread going off track and being highjacked, I've put my thoughts in spoiler section to let you know how I think. Please don't reply. I will add a new thread for my case and will ask for your advice there. Thanks.