how do I 4

[Lhuffst]

I have an odd request from the customer. One of the fields is total gallons which can be hundreds, thousands or more
This is not a problem.

Now they want to add another field that shows only the thousands of gallons based on the first field. How do I do that?

for example

Total Gal: 181700 Thousands Only: 181
Total Gal: 700 thousands Only: 0
etc.

Do I check length and divide by 1000?
thanks

 

[SkipVought]

Why would you check the length? It's a NUMBER, which has no "length."

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[dhookom]

You don't have to store the value, just add a text box with a control source of:

=[total gallons]\1000

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

 

[Lhuffst]

dHookom.
That's what I tried originally

Total Gals: 132580 puts thousands as 132.58

I only want the 132

 

[Lhuffst]

I moved the formula to the form on current

I changed the text box
decimal places: 0
format : 0000

This looks now
Thanks

 

[Andrzejek]

If you would try exactly what Duane is suggesting, you would get the value of 132 back
Pay attention to the division sign: \ (not /)

Have fun.

---- Andy

There is a great need for a sarcasm font.

 

[dhookom]

Thanks Andy

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

 

[SkipVought]

Integral division.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[Lhuffst]

my mistake. Thank you guys

 

[kjv1611]

Thanks to Duane and Skip. I don't think I've ever personally seen or used that setup before. Good to know in case I need it in the future.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57