Looking at this video at 9:33minutes, i dont understand why you opt to use the round off function in a querry instead of the "decimal places" just below the format property in the open dialog box (field properties).
Is there a specific reason? I have to admit i did not know the round off function before. I had opportunity to learn it in this 220 video however i was curious that that there could be a reason that you perhaps did not mention.
Please let me know. Thank you!
MICAH
Reply from Richard Rost:
Both work just fine. I guess my way goes back to my old Visual Basic programming days where we HAD to use the Round() function in code... we couldn't rely on the decimal property for our text boxes. I probably should have mentioned that in the video. :)
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Microsoft Access 220.