Search results

or look thisd that is even simplier with less agent i have tried with the previuous version and it work..so i don't know what happen with some modification that has been done

look here, pierluigino is inactive from 12/6 but if i make a sales..any sales after 12 from his affilate Genoveffo he still get commission Also i have notice that even if Pierluigino is inacive i can choose him for a sale..while is better to do not have this chance and see i cannot see the...

i am having problem with the inactive user...once i set the inactive date for user..commission are still calculated for him and not anymore to main agemcy (Capital1 now) Is th e INATTIVO user needed for this?

great seems fine now After a SALES in the report page i don't find the sale..i have to close and reopen the db..so it will need a requery to be update Also ..i create a structure, and then i cnage it..i see in the structure the date of th eorganization but if i click on it nothing appear and...

yes i removed the date() criteria and the table is deleted..i don't know if i made something that should not be done anyway anyway a coule of table don't have the queires to delete their data, the tablkes sales and subordinates

i have run the queries on your latest update version capital2..agent are cleared but not all the other tables are deleted, i see there is criteria "date() may be to be removed in the queries that don't delete. Also i don't see the organization being updated when changing yet.

i have just tried to manually delete all the table content but the one with commission after that there is something that don't work properly anymore so i really need to check what to delete Of course i understand the fact that i cannot delete once "in production" but i am doing test an dbefore...

thanks! MajP has done a big and fantastic work that is working for the pourpouse!

just to be synchronized i attach the db at this point

after few days i am working again at it, changing at first all the test to italian I want to clear the datas..but i see i cannot remove agents..and may be the archived organizitation How do i do that? i have set as inactive thge agents..but still cannot delete Also if i change the status...

yes right..in some cases reading your code i can write mine..i don't know vba but i know the logic of coding..so it might help

your button stil have code though i see that if use th eoption of the report "builtin macro" on the click property of the report i can also specify there some where condition..it is anothe possible option?

Ok butnthe way you need writing code skill, right?may be not the best for me I can also set the where condition at report level so i don t need to create a query copy for each report, is it?

yes maschere means form I also hate the input mask..but how to sort? it is not nice to let the uiser write the date..there must be a proper calendar control Also look i have added another report Just tell me if it the correct way to go on..i put the filter condition in the query i use for...

look i have added a new report to last sheet of th emask You need to insert the 2 date dd/mm/yyyy..(i coudn't find how to insert it from a calendar) it seems working

sure..what i meant was..start from queies and not from table!

to buil dthese records i need to use the queries as data source?for example the query royalties by month is ht eo ne i should use for the report with filtering which month..right?

so it should be more or less completed and working now..i think 1 important report is still needed..the one of sales by month..with month to be choosen before outputting the record..what you think?

yes it is like this It's even difficult to make a test of this scenery on th eDB now... but i trust it works :)!

yes ok it is what i meant...the royalties are calculate according to the current structure, and are shwon according to the structure at moment of sale