Recent content by OracleScorpion

Okay folks, I've got what I need and it looks good ^-^. Thank you!

I already know that I will have to use a query, but am still completely in the blue. I showed the tables which I have and the user gets a screen in which to choose the LoadingPort, DestinationPort and Agent. Agent is not necessary to choose. Out of these choices (and after pushing a button), the...

Thank you both, I'm going to try both ways and see which one the users prefer. Thanks!

I have one form with only text on it to show when the user clicks a button. Now the form is very long (longer than te screen) and I already tried everything but it won't work. I'm trying to show only a small screen with a scrollbar so the user can just scroll down to read on. I put all the right...

Hi, I have one main table which pulls information from other tables. In the main table is information and links via autonumbering to the other tables in order to fill in the gaps. Now the problem is on how to pull the necessary information and make a graph of it. The tables will be put down...

*sighs* thank you once more! It's a saturday evening and I'm working on a project for work, my apologies that my brain is slightly in weekend-mode *blushes* Thank you ^-^

Ack... now you say so. Normally at work I use the english version. But here at home I have the dutch version and I am not used to the names in it. Thanks a bunch! Just one more question. I need to get a comma as limiter for decimals, any idea how to?

In my database, I've got a numeric field which has to store up to 7 numbers of which 2 are decimals. Now I tried everything in the notation and number of decimals etc but whatever I do, it keeps going wrong. If I fill in 59,31 (the 31 is the decimals) I get as a result either 5931 of 59. Can...

Okay... I looked up for the SUMPRODUCT and it gave the right result. I don't fully understand it, as when I tried it before and did exactly the same things, it gave an error as well. So I don't know what or how, but now it seems to work. Lets cross fingers that it will work on every one of the...

=D3:D9

Well I am just trying it on different sheets, that's why at the moment it doesn't matter what cells I'm trying. Oh and they are on the same sheet. But what do you mean with key combination?

=SUM(ROUND(A1:A10,2)) But then of course with the range that I need. I keeps flipping back to the range, as if it can't accept a range there...

Eh... the error is literally "the formula contains an error". I can't be more specific because that is all Excel is tell me...

Ken : I tried them, but kept getting errors :(

No, we have to show the numbers as rounded. Difficult to explain, has to do with the weights and whatever. You know, money ;) I'll try the Precision right away, but won't this affect the other numbers as well then?