If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
anybody not use caculation
I wonder if some people choose not to use caculation for access? As I
creating my database, i found it is a pain to use formulas, because sometimes they don't end up linking to each other.. I would like to hear how others handle with caculation.... I am thinking of removing those, and just have users to add and subtract it themselves before inputting into the database. It will be much easier for them to run reports stuff like that, isn't it???? Just simple math i think they can handle,,,,hmmmmmmm,,,,, Thanks! -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
anybody not use caculation
Hi.
As I creating my database, i found it is a pain to use formulas, because sometimes they don't end up linking to each other. Developers get paid the big bucks to solve these problems. If you don't know how, take some classes or team up with a mentor, or get a tutor to teach you how, or post questions in the newsgroups. Access has a steep learning curve so it takes some time to learn how to use it properly. Getting some help from someone more experienced will speed up the learning process tremendously. I am thinking of removing those, and just have users to add and subtract it themselves before inputting into the database. It will be much easier for them to run reports stuff like that, isn't it???? Just simple math i think they can handle,,,,hmmmmmmm,,,,, Never underestimate the ability of folks who know how to add and subtract, but can't type. If you want your database applications to rely on the users for data integrity and data validation, please hand the "Access Developer" hat to someone else before you get fired! HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info. "accessuser via AccessMonster.com" u28669@uwe wrote in message news:6aebefbc4f500@uwe... I wonder if some people choose not to use caculation for access? As I creating my database, i found it is a pain to use formulas, because sometimes they don't end up linking to each other.. I would like to hear how others handle with caculation.... I am thinking of removing those, and just have users to add and subtract it themselves before inputting into the database. It will be much easier for them to run reports stuff like that, isn't it???? Just simple math i think they can handle,,,,hmmmmmmm,,,,, Thanks! -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
anybody not use caculation
i am not a acccess developer. I am just picking up project to help out, and
this is only my second database, but first database involving caculation.... and just wondering which way is better....,,,,i was able to solve some problems, but just wasn't usre how others treat caculation in access.....but thanks for your reply, now i know developers get paid for big bucks.... '69 Camaro wrote: Hi. As I creating my database, i found it is a pain to use formulas, because sometimes they don't end up linking to each other. Developers get paid the big bucks to solve these problems. If you don't know how, take some classes or team up with a mentor, or get a tutor to teach you how, or post questions in the newsgroups. Access has a steep learning curve so it takes some time to learn how to use it properly. Getting some help from someone more experienced will speed up the learning process tremendously. I am thinking of removing those, and just have users to add and subtract it themselves before inputting into the database. It will be much easier for them to run reports stuff like that, isn't it???? Just simple math i think they can handle,,,,hmmmmmmm,,,,, Never underestimate the ability of folks who know how to add and subtract, but can't type. If you want your database applications to rely on the users for data integrity and data validation, please hand the "Access Developer" hat to someone else before you get fired! HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info. I wonder if some people choose not to use caculation for access? As I creating my database, i found it is a pain to use formulas, because sometimes [quoted text clipped - 5 lines] Thanks! -- Message posted via http://www.accessmonster.com |
#4
|
|||
|
|||
anybody not use caculation
Hi.
i am not a acccess developer. I am just picking up project to help out If you're creating an Access database (as you explained in your first post) or altering an Access database's design, then you're wearing an Access developer's hat, even if your official job title is something else, such as newspaper reporter or office manager. this is only my second database, but first database involving caculation.... and just wondering which way is better....,,,,i was able to solve some problems, but just wasn't usre how others treat caculation in access. We use a _lot_ of calculations (called "expressions"), because we want the computer to do as much of the tedius, repetitive work as possible, not the users. The computer can do mathematical and logical operations for days on end and never complain or produce an error, which is something that humans would have difficulty doing, nor should they have to, since humans can do complex activities and make complex decisions that are impossible for computers to perform. If you need help with formulas or advice on how to do something, just post a new question in the newsgroups and someone will try to help you. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info. "accessuser via AccessMonster.com" u28669@uwe wrote in message news:6aec8e5e1bb7a@uwe... i am not a acccess developer. I am just picking up project to help out, and this is only my second database, but first database involving caculation.... and just wondering which way is better....,,,,i was able to solve some problems, but just wasn't usre how others treat caculation in access.....but thanks for your reply, now i know developers get paid for big bucks.... '69 Camaro wrote: Hi. As I creating my database, i found it is a pain to use formulas, because sometimes they don't end up linking to each other. Developers get paid the big bucks to solve these problems. If you don't know how, take some classes or team up with a mentor, or get a tutor to teach you how, or post questions in the newsgroups. Access has a steep learning curve so it takes some time to learn how to use it properly. Getting some help from someone more experienced will speed up the learning process tremendously. I am thinking of removing those, and just have users to add and subtract it themselves before inputting into the database. It will be much easier for them to run reports stuff like that, isn't it???? Just simple math i think they can handle,,,,hmmmmmmm,,,,, Never underestimate the ability of folks who know how to add and subtract, but can't type. If you want your database applications to rely on the users for data integrity and data validation, please hand the "Access Developer" hat to someone else before you get fired! HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info. I wonder if some people choose not to use caculation for access? As I creating my database, i found it is a pain to use formulas, because sometimes [quoted text clipped - 5 lines] Thanks! -- Message posted via http://www.accessmonster.com |
#5
|
|||
|
|||
anybody not use caculation
if you're writing a database that is going to be used in a "real world"
situation, and people (your company) are going to depend on the database to handle one or more "real" work processes, then you *are* an Access developer - the question is whether or not you want to do the hard work to become a good one, whose customers (your bosses and/or co-workers) can depend on to develop, deliver, and support a quality product. to answer your specific question: it makes absolutely no sense to have users do the work of entering masses of data into a database that has the powerful tools offered by Access - and then make those users do the math manually. if you have raw numbers stored in one or more tables, then you should create the queries, etc, to do whatever math calculations are needed. and if you don't know how, then learn. there are absolutely tons of resources available for learning Access skills, from basic to advanced - in print, in various college and continuing education classes, and on the internet, not least of which are these newsgroups - all available to anyone who has the desire to learn. hth "accessuser via AccessMonster.com" u28669@uwe wrote in message news:6aec8e5e1bb7a@uwe... i am not a acccess developer. I am just picking up project to help out, and this is only my second database, but first database involving caculation.... and just wondering which way is better....,,,,i was able to solve some problems, but just wasn't usre how others treat caculation in access.....but thanks for your reply, now i know developers get paid for big bucks.... '69 Camaro wrote: Hi. As I creating my database, i found it is a pain to use formulas, because sometimes they don't end up linking to each other. Developers get paid the big bucks to solve these problems. If you don't know how, take some classes or team up with a mentor, or get a tutor to teach you how, or post questions in the newsgroups. Access has a steep learning curve so it takes some time to learn how to use it properly. Getting some help from someone more experienced will speed up the learning process tremendously. I am thinking of removing those, and just have users to add and subtract it themselves before inputting into the database. It will be much easier for them to run reports stuff like that, isn't it???? Just simple math i think they can handle,,,,hmmmmmmm,,,,, Never underestimate the ability of folks who know how to add and subtract, but can't type. If you want your database applications to rely on the users for data integrity and data validation, please hand the "Access Developer" hat to someone else before you get fired! HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info. I wonder if some people choose not to use caculation for access? As I creating my database, i found it is a pain to use formulas, because sometimes [quoted text clipped - 5 lines] Thanks! -- Message posted via http://www.accessmonster.com |
#6
|
|||
|
|||
anybody not use caculation
On Mon, 18 Dec 2006 02:46:19 GMT, "accessuser via AccessMonster.com"
u28669@uwe wrote: I am just picking up project to help out, and this is only my second database, but first database involving caculation.... and just wondering which way is better....,,,,i was able to solve some problems, but just wasn't usre how others treat caculation in access... Calculation is difficult and relatively slow, and prone to errors, for most humans. It's easy, fast, and accurate for computers. Why not have the computer do the calculations!? John W. Vinson[MVP] |
#7
|
|||
|
|||
anybody not use caculation
Well said, Tina. Aren't you an MVP by now? :-)
Gunny "tina" wrote in message ... if you're writing a database that is going to be used in a "real world" situation, and people (your company) are going to depend on the database to handle one or more "real" work processes, then you *are* an Access developer - the question is whether or not you want to do the hard work to become a good one, whose customers (your bosses and/or co-workers) can depend on to develop, deliver, and support a quality product. to answer your specific question: it makes absolutely no sense to have users do the work of entering masses of data into a database that has the powerful tools offered by Access - and then make those users do the math manually. if you have raw numbers stored in one or more tables, then you should create the queries, etc, to do whatever math calculations are needed. and if you don't know how, then learn. there are absolutely tons of resources available for learning Access skills, from basic to advanced - in print, in various college and continuing education classes, and on the internet, not least of which are these newsgroups - all available to anyone who has the desire to learn. hth "accessuser via AccessMonster.com" u28669@uwe wrote in message news:6aec8e5e1bb7a@uwe... i am not a acccess developer. I am just picking up project to help out, and this is only my second database, but first database involving caculation.... and just wondering which way is better....,,,,i was able to solve some problems, but just wasn't usre how others treat caculation in access.....but thanks for your reply, now i know developers get paid for big bucks.... '69 Camaro wrote: Hi. As I creating my database, i found it is a pain to use formulas, because sometimes they don't end up linking to each other. Developers get paid the big bucks to solve these problems. If you don't know how, take some classes or team up with a mentor, or get a tutor to teach you how, or post questions in the newsgroups. Access has a steep learning curve so it takes some time to learn how to use it properly. Getting some help from someone more experienced will speed up the learning process tremendously. I am thinking of removing those, and just have users to add and subtract it themselves before inputting into the database. It will be much easier for them to run reports stuff like that, isn't it???? Just simple math i think they can handle,,,,hmmmmmmm,,,,, Never underestimate the ability of folks who know how to add and subtract, but can't type. If you want your database applications to rely on the users for data integrity and data validation, please hand the "Access Developer" hat to someone else before you get fired! HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info. I wonder if some people choose not to use caculation for access? As I creating my database, i found it is a pain to use formulas, because sometimes [quoted text clipped - 5 lines] Thanks! -- Message posted via http://www.accessmonster.com |
#8
|
|||
|
|||
anybody not use caculation
"accessuser via AccessMonster.com" u28669@uwe wrote in message
news:6aebefbc4f500@uwe... I wonder if some people choose not to use caculation for access? As I creating my database, i found it is a pain to use formulas, because sometimes they don't end up linking to each other.. I would like to hear how others handle with caculation.... I am thinking of removing those, and just have users to add and subtract it themselves before inputting into the database. It will be much easier for them to run reports stuff like that, isn't it???? Just simple math i think they can handle,,,,hmmmmmmm,,,,, Imagine the response you will get from your users. "Where's the total of that column gone?" "Well it was a pain for me to code it so you'll have to work it out for yourself from now on." You won't be winning any popularity contests. Keith. |
#9
|
|||
|
|||
anybody not use caculation
When people ask me what a programmer/developer does, my stock answer has
always been "Developers spend hours and hours solving one problem so that the end user can solve the same problem, hundreds of times in an hour , and always get it right!" -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200612/1 |
#10
|
|||
|
|||
anybody not use caculation
I shorten that to:
I do it so that they don't. "missinglinq via AccessMonster.com" u28780@uwe wrote in message news:6af06945a28ec@uwe... When people ask me what a programmer/developer does, my stock answer has always been "Developers spend hours and hours solving one problem so that the end user can solve the same problem, hundreds of times in an hour , and always get it right!" -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200612/1 |
Thread Tools | |
Display Modes | |
|
|