Search results

Hi, Anyone able to give me some more help on this one? I am fighting hard not to change with my project to excel (where my problem is solved by one simple formula "SUMIFS") but my deadline is close... Thanks a lot for any help on this ... I was thinking very simple issue

Dear Colleagues, Is there anyone able to help me with this simple problem? After some discussion, I still do not know how to do what I want, which is: - to have in my AllData Query of attached ACCESS DB the additional columns showed in attached excel in columns S:Y (I show the logic I want to...

Hi, Hmm... I think I have attached it in the ACCESS.zip archive. At least I can see and open the database from attached zip

OK, So point by point: 1. You write I need each query for each discount - but what should be in this query? I was trying to add all the fields from tables that contain the fields present in a given discount table (I attach it). 2. constructing the queries in the way described above, I added it...

Hi, thanks a lot for the hint. I tried to apply the article hints to my DB, but was not successful with this. Would it be possible you add just one discount to my query with all data so that I could have a good base for adding other? Thanks a lot in advance...

Hi vbaInet, Sorry, I was travelling a bit. I attach the excel with results I would like to get in AllData Query. The query columns I fight with in Access are shown in excel S:Y range - with proper excel formulas to the Ded Tables (kept in Ded_TABLES sheet). I hope this is more clear now what I...

... HMM the issue is that customer can get a discount because of some features belonging to "being a customer" (For instance if he is within the purchase group, or international, then he gets higher one), but as well because of some features belonging to "products he takes" (for instance, if he...

Hi, I attach the database (changed the data, but all the dimensions and links stay as in my original one) and the error, when trying to add DedVDT containing Volume Discount. The idea is, to have the % discounts in the same form for each record, as prices and volumes..

Thanks vbaInet for your hint. This works of course. Let me describe my 2nd part of the problem... Each discount has at least two conditions, for instance: if customer is International and PPType = "AS" then discount = 4% etc the tables storing dimensions used for those conditions (In this case...

hi, I am trying the following: Query name: TGT_VolumeandPrices Customer, PurchasedProductType1, PurchasedProductType2, InternationalLocal, PurchasedProductCode, PPPrice, SalesVolume2013 Values of this query: cocacola, AS,zx,I,333,20.33$,1000 pepsico,WE,ws,I,443,44.90$,500.55...

Hi All, I am new to MS Access, trying to build my first Budget database that would calculate Net Sales for few companies. The problem description: I have a query build with 2 linked (with referantial integrity) tables, consisting of the following dimensions: Query name: TGT_VolumeandPrices...