INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

how do I

how do I

(OP)
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

RE: how do I

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

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: how do I

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

CODE --> ControlSource

=[total gallons]\1000 

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

RE: how do I

(OP)
dHookom.
That's what I tried originally

Total Gals: 132580 puts thousands as 132.58

I only want the 132

RE: how do I

(OP)
I moved the formula to the form on current

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

This looks now
Thanks

RE: how do I

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.

RE: how do I

Thanks Andy smile

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

RE: how do I

Integral division.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: how do I

(OP)
my mistake. Thank you guys

RE: how do I

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close