force 1 decimal place at all times

[megamef]

Hi All,

I'm using a calculation on my form that subtracts one number from another and stores the difference between the two in a 3rd field. This works correctly but I want the difference to show 1 decimal place at all times.

So for instance if subtract 35.1 from 35.2 I get a difference of "0.1".

But if I subtract 35.0 from 36.0 I get a difference of "1".

The first case is fine but I need the difference to be "1.0" in the second case.

I've set the number of decimal places in the table from auto to 1 and changed the format on the form to a standard number with 1 decimal place. Neither of these show a difference of 1 as "1.0"

Anyone know how to force 1 decimal place at all times?

Cheers

Steve

 

[pr2-eugin]

I stopped reading after this..

Hi All,

I'm using a calculation on my form that subtracts one number from another and stores the difference between the two in a 3rd field.

Do not take trouble for yourself, do not store calculations, perform them when and where required.http://allenbrowne.com/casu-14.html

 

[megamef]

I'm sorry, I understand that this might not be the correct way to go about this but this job is just a quick thing I need to sort out.

The table of the database is connected via mail merge to another document that is formatted correctly with the right fields in the right place so i have to keep the table i'm using.

I just want to find out how to force 1 to 1.0. I'll take your message about proper database construction into consideration in the future but I need to get this out the way at the moment.

If you do know know how to make force the decimal and could tell me that would help me out a lot

 

[pr2-eugin]

The table of the database is connected via mail merge to another document that is formatted correctly with the right fields in the right place so i have to keep the table i'm using.

You do realize Mail Merge documents can also look into Queries in a Database, so why not create a Query to calculate the third column, then do the same?

Or

Why not use a Format in the Mail Merge field instead of doing it in the table?

I'll take your message about proper database construction into consideration in the future but I need to get this out the way at the moment.

Based on experience and other user interaction this is not a possibility, if you want to learn/make a properly sound DB, you have to start it right NOW. Not tomorrow, not next week, but now.

If you do know know how to make force the decimal and could tell me that would help me out a lot

I have one thing to say for this:

Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.

If you want a fish, I am sure you will get it sooner.