Search results

write in another post for better undertanding After first test, and having checked that those "two issues"..are not really issues.. it looks that everything is fine Stil..that "issues of main agent being 0 and 9 can be solved only rewriting the whole structure righ? A query in the Royalties...

ok doing some test may be i have found a couple of issues 1) i have deleted the third level of agents for better understanding..and now i want to create a new third level agent I can set the name, "the reports to", but it seems i cannot set the "agent level" field", just cannot wirte in..and it...

ok did not have really time to study it properly yet..i have plenty of info to take and it is not my language...so i need a while to sit and convetrate on the db and all the info you provide me i know it works..it s me that still can t make it work!:D

not sur i understand.. all the calculation we are doing inthis table is what is to be shared. let's say we got yhe monthly report of 1000 euro generated from a customer, john doe, linked to an agent in level3 John Doe has bought from a DEALER for 1500 euro So those 1000 euro are already, of...

no..a acces file is mnore than enough...we ar enot going to talk about many agents included in the whole structure..i think form 10 to 15 is more than what i could reasonable expect. This is why the need for somehting easy and small...

main agency is the main office that employes all the agent Main agency always get a percentage then So in case there are 3 lines of agents, the income would be share for 4 subjects In case there is only one line the income would be shared for 2 subjects It's not easy to understand the db you...

ok i will see that in a second time, first need to learn this help me to understand like it is now every sales just add the amount of royalties to each agent(in case the agent is included) right? imagine i have a report every month of the income genrated by agent 1, agent 2 ecc And every mont...

wow that s is wonderful thank you thank you let me study it need to understand!! So i can do everything through the MAIN mask right? Onb emore thing..is it possible to use some seacrh function to see how much an agent or in total has been earned within a certain period of time?

who tell you tha agents will be got?:) i just do the db..and knowing the people i reckon 4 or 5 agents will be there..And after that i don't see any sales from them :) ..but the want to be ready..and i do the db!

before i start to study your example let me answer Yes the percentage will change according to who make the sale If level 3 make the sale, the percentage is to be divided with all the superior level, so with main agency, level 1 and level 2 example m.a. 40% - level1 30% - level2 20% - level3...

not exactly the same question...here i have asked a specific thing pn how to join 2 records on same table whih i did not mention at all inother forum

thanks for the prompt response..i am afraid i don't undertsand how to proceed ALso keep in mind..just to understand if my procedure is going the proper way..that i will need to set a commission table also this is the example of the whole thing

Hello i am building a scheme for a multlevel marketing and i need to relate agents o other agents so i am builfding the agents table using this scheme AgentPK....AgentName....ReportsTo 1..............A..................null (this is a top agent) 2..............B..................null (this is...

sorry about, i though i posted it but i find out not so i post the excel file which i simplified and this refer to this post https://www.access-programmers.co.uk/forums/threads/how-could-i-do-that-with-access.312732/post-1707332 i copy/paste it again for better understanding each row it is not...

sorry i am afraid i don 't understand what you said 🙁

are you talking about my first excel or latest? in the lates called test excel short there for column 003 000 there are 3X Look at it, is simplified, i cut rows and columns for a better undertsanding

each row it is not random. each row is fixed the row I001 will be all the time the same sequence of character i will put the same excel file with much lessa data so coul be easier to understand The table, as you see is fixed it is a schema ti undertsand how value are related to each other I...

what i will input are those string, the row ones as in the previous image, for example i input the I001 string I001 string it is an one row array of character suppose that we have 10 column the string will contain 10 characters (i consider character also the blank space) so I001 will looks...

i know, it is not easy to explain, also i had to understand it as it is not my project and i know how complcate is I will try later to explain in some other way if you have question that my address me please go on

sorry in my post i have create something not base on the excel table. i made it quick just to be able to show immediately what i mean So data in the table are differnt form the esemple i write , but logic is the same