Search results

Gemma-the-husky, thank you for your example (I thought I replied earlier but the computer I'm currently on isn't the best so...)! I will test it during the weekend and - most certainly - ask some more questions as the system develops. Cheers, D

Gemma-the-husky, thank you very much for the example! I really appreciate you taking your time writing it and I will fiddle with the example and see if I can come up with something... Right now I'm struggeling with the database design, so lets see when I feel more comfortable with it... Cheers, D

Gemma-the-husky, I think I understand your reasoning, however I have no idea how that would be done in practice. Could you perhaps direct me to an example (if any) or explain the process a bit more in detail? I'm liking the idea of having a single function going through an array of covenants...

The_Doc_Man, thanks for the tip about Eval! Had never found out that one myself... I think it could be a quite good way to evaluate the rules, as it I cannot fathom that there will be more than max 5 rules at any given time that will be evaluated (I will of course try to be 100 % on it...

Thanks for your input The_Doc_Man. The covenants will never be more complex then: a) compare a number against another number (e.g. x > 5, where x would be perhaps a 3) b) compare a number against a margin ratchett, example: if X is between 4 or 5 then margin 2 if X is beteen 3 or 4 then...

Thanks everybody for the input! I feel that I have to explain a bit better what I'm trying to achive. So to clarify, the users are only going to add rules that are in the basis of: x = some covenant if x<=10 then rating is Y and if not, then it's not fulfilled (and the system would flag it as...

georgedwilkinson, thanks for the input! I have a feeling it can be quite a lot of work, but I don't know how to solve the problem in another way. As the rules for the financial covenants change over time and are different to each company, I cannot see how you could get an overview in excel...

Hey everybody, This is my first post so, hi everyone ;) Background to project: I'm trying to set together a database which is supposed to function as a storage database and which should be able to produce a monthly overview in excel. More specificly, what I want stored in the database is i)...