Recent content by PrinceNai

As I said, the solution is clumsy at best. There is nothing wrong with query names or form and control references. The reason I think so is that when I went from select to maketable query I only changed two things. Query name was qry_YearlyLoss and it now creates tbl_YearlyLoss. Nothing was...

Thanks a lot for your answer, will try to do it. In the meantime I went the "dumb" route. Changed those two queries from select to maketable and based my charts on those new tables. Far from elegant, but it works :)

Dear Sirs, I have a form with two charts on it. Those charts are based on two queries. When designing the form I made those two queries with explicit criteria (ID). It worked as expected, charts were drawn. Next thing I did was to add a combo box, where I pick a certain surname and this feeds...

Thank you for the ideas so far. After reading them I was at least able to form a clearer picture of how the results should look like. 1. The numbers may repeat, but ideally they should not all be the same (the last one isn't, since it is a remainder) 2. The number of smaller numbers isn't...

Dear All, I'd like to automatically split any number larger or equal to 10.000 into smaller random numbers, rounded to hundreds (the input never has tens or ones other than 0 and is never less than 10.000). So, if a user enters 11.100, to let's say 8.000 and 3.100. If they enter 20.000, into...