 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / January 2005formulas
I am trying to create a database for payroll. I need ti insert formulas in access. Can anyone refresh me on how to do that? Formulas can be used in many places in Access. In query design view ... ACalculatedColumn:[ARealColumn]*[AnotherRealColumn] ... in SQL ... SELECT ARealColumn * AnotherRealColumn AS ACalculatedColumn FROM ATable ... in ControlSource, DefaultValue, and other properties ... =[ARealColumn] * [AnotherRealColumn] ... and in code ... Public Function Whatever (ARealColumn As Long, AnotherColumn As Long) As Long Whatever=ARealColumn * AnotherColumn End Function My advice is to run, very fast, as far as you can get from payroll. Horrible, horrible stuff. There's perfectly good payroll packages on the market for ridiculously low prices. Use one, let someone else suffer! :-)  SignatureBrendan Reynolds (MVP) http://brenreyn.blogspot.com The spammers and script-kiddies have succeeded in making it impossible for me to use a real e-mail address in public newsgroups. E-mail replies to this post will be deleted without being read. Any e-mail claiming to be from brenreyn at indigo dot ie that is not digitally signed by me with a GlobalSign digital certificate is a forgery and should be deleted without being read. Follow-up questions should in general be posted to the newsgroup, but if you have a good reason to send me e-mail, you'll find a useable e-mail address at the URL above. >I am trying to create a database for payroll. I need ti insert formulas in > access. Can anyone refresh me on how to do that? > My advice is to run, very fast, as far as you can get from payroll. > Horrible, horrible stuff. There's perfectly good payroll packages on the > market for ridiculously low prices. Use one, let someone else suffer! :-) ROFL.... you are so right, but payroll is probably 10 times easier than Accounts Receivable... <g> SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.