in database "specify Calculation" how do I make 7.75 automaticly become 0.0775

basicly I need to know how to move decibils over 2 spots?

also when i have it compute 0.0775 it comes up with:

2486.975 how do I make it so in the 5 position would round up if 5 and over. and round down if under 5 basicly Im working with money.

well, this is how i do it, but it requires a script.

make (2) fields one is the field you enter into 7.75, the other is a calculation field that divides the 7.75 number by 100.

make the field that has the 7.75 underneath the field that contains the calculation , and make it so you don't see it, then have a script go the the 7.75 field, and then when you hit the tab or enter key, (depending on which fm version you are running) you will then only see the .0775 answer.

e.g.

field - testDecimal = just a number field

field - testDecimalFinal = calculation of testDecimal / 100

hope this is clear to you.

Blue

Thank you for your help. im such a brain dead, I didnt even think of the / 100 thing: heres how I made it easier!

If ( retailwholesalelease = "Retail" ; Round ( ( (cashprice + doc. charge + Smog) * (Tax Percent / 100) ) ; 2 ) ; 0 )

Hi Adam, hi Blue. If you guys are using version 7, you can actually set the auto-enter options for a field to auto-enter (fieldName / 100) and, when you enter 7.75 into that field, it is automatically replaced with .0775. Isn't that cool? (Trying to be positive about FM as it seems to be taking a little bit of a beating lately

Jerry

thanks I will play around with that, and yea people seem to be flaming FM 7 alot lately, so far I think its a great program, im making a setup to automate my Car dealership, right now im making the contract stuff and calculations automatic. My next feat which im still unsure how to do is making a search button. I asked about it before about a week ago, but am still confused. Im trying to make a global field with a button next to it so when I push the button it finds and goes to the record with the field Stock# that matches the search field. any ideas??

SO: you have a global where you enter a search criteria, then press a "Search" button, and you want to find all records where some other field matches what you've entered?

If so, then your script should read:

Set Error Capture [On]

Enter Find Mode [DO NOT Restore Find Requests, DO NOT Pause]

Set Field ["theSearchField" , "theGlobal"]

Perform Find [Replace Found Set, DO NOT Restore Find Requests]

If ["Status ( CurrentFoundCount ) = 0"]