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

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

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

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

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

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]

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

"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.

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

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