anybody not use caculation

[accessuser via AccessMonster.com]

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!

 

['69 Camaro]

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/expert_contributors2.html for contact info.

 

[accessuser via 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....

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/expert_contributors2.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!

 

['69 Camaro]

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/expert_contributors2.html for contact info.

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

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/expert_contributors2.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!

 

[tina]

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

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

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/expert_contributors2.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!

 

[John Vinson]

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]

 

['69 Camaro]

Well said, Tina. Aren't you an MVP by now?

Gunny

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

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

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/expert_contributors2.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!

 

[Keith Wilby]

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.

 

[missinglinq via AccessMonster.com]

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

 

[David F Cox]

I shorten that to:
I do it so that they don't.

 

[accessuser via AccessMonster.com]

Well say all,,,,Thanks for the info,,,,,i've spent so much on the following,
can someone help me on the query,,,,,


John Doe
Course1 Total Company Assistance
Course2 Total Company Assistance
Course3 Total Company Assistance

Grand Total of all: Total Company Assistance

Run a query that returns the result of the GrandTotal is greater than 2000
for each person.

I was able to do the grand totals in form and reports but users have to print
all employees report and see if the total is over than a specifc amount....is
there a way to do it in query or has to do in the form and report?


Thanks!!!

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

[quoted text clipped - 6 lines]

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.

 

[Keith Wilby]

Hi Keith

Wasn't me guv!

Keith.

 

[David F Cox]

I have succeeded in not learning English fully in 6 decades, so good luck in
that. -<)

 

[Lynn Trapp]

Well said, Tina. Aren't you an MVP by now?

She ought to be, as should YOU! This is the consensus of everyone.

 

[John Vinson]

Well said, Tina. Aren't you an MVP by now?

Looked in a mirror recently, Gunny? <g>

John W. Vinson[MVP]

 

[John Vinson]

Well say all,,,,Thanks for the info,,,,,i've spent so much on the following,
can someone help me on the query,,,,,


John Doe
Course1 Total Company Assistance
Course2 Total Company Assistance
Course3 Total Company Assistance

Does your TABLE have three fields named Course1, Course2, and Course3?
If so, your table structure is *wrong*. What will happen when someone
takes a fourth course?

Grand Total of all: Total Company Assistance

Does your TABLE have a field Total Company Assistance? If so, your
table structure is *even worse*.

Please explain your actual table structures. They may be fine, and
these may be correct derived fields in a query - but I really worry
that you're "committing spreadsheet on a database"!

Run a query that returns the result of the GrandTotal is greater than 2000
for each person.

I was able to do the grand totals in form and reports but users have to print
all employees report and see if the total is over than a specifc amount....is
there a way to do it in query or has to do in the form and report?

If you want to see *both* subtotals and grand totals at the same time,
it's much easier to do so on a Form or Report. It can be done in a
query, using two queries in a UNION, but since users shouldn't be
looking at query datasheets in any case, why bother?

John W. Vinson[MVP]

 

[accessuser via AccessMonster.com]

I have the following tables;

TblEmp
EmpID (PK)

TblCourseInfo
CourseID (PK)
EmpID (FK)

TblCost
CostID (PK)
CourseID (FK)

FrmMain with TblEmp info, FSubCourseInfo has CourseID, which has course 1,
course 2, course 3 etc....,,..and I have FrmCost, after the users input their
Courseinfo in the Subform, there is CmdAddCost, opens up Cost form, and input
the info by using CourseID, so make sure they will link to each other later
on.....

I created a query base on formulas which I use for my reports and forms. On
the reports, it lists all those courses each person took, and total company
assistance for each course, and then on the footer, i put unbound box and use
the formula to add them as grandtotal.....I am just wondering if there is a
way that i can set up something like click a command button, and it will
generate a the result i want such as "Return Anybody who has Grandtotal of
$2000" for 2006"

I got some tips from this site on formulas for my forms and reports, and they
are working fine, just curious if there is a way for my question, otherwise,
managers will have to look through each employees and their costs...

Hope I am making sense..

Thanks!

Well say all,,,,Thanks for the info,,,,,i've spent so much on the following,
can someone help me on the query,,,,,

[quoted text clipped - 3 lines]

Course2 Total Company Assistance
Course3 Total Company Assistance

Does your TABLE have three fields named Course1, Course2, and Course3?
If so, your table structure is *wrong*. What will happen when someone
takes a fourth course?

Grand Total of all: Total Company Assistance

Does your TABLE have a field Total Company Assistance? If so, your
table structure is *even worse*.

Please explain your actual table structures. They may be fine, and
these may be correct derived fields in a query - but I really worry
that you're "committing spreadsheet on a database"!

Run a query that returns the result of the GrandTotal is greater than 2000
for each person.

I was able to do the grand totals in form and reports but users have to print
all employees report and see if the total is over than a specifc amount....is
there a way to do it in query or has to do in the form and report?

If you want to see *both* subtotals and grand totals at the same time,
it's much easier to do so on a Form or Report. It can be done in a
query, using two queries in a UNION, but since users shouldn't be
looking at query datasheets in any case, why bother?

John W. Vinson[MVP]

 

[John Vinson]

I have the following tables;

TblEmp
EmpID (PK)

TblCourseInfo
CourseID (PK)
EmpID (FK)

TblCost
CostID (PK)
CourseID (FK)

Ok... those look good...

FrmMain with TblEmp info, FSubCourseInfo has CourseID, which has course 1,
course 2, course 3 etc....,,..and I have FrmCost, after the users input their
Courseinfo in the Subform, there is CmdAddCost, opens up Cost form, and input
the info by using CourseID, so make sure they will link to each other later
on.....

but this isn't communicating to me. What is the Recordsource property
of FSubCourseInfo? Does it have separate Controls for Course1,
Course2, Course3? If so, what are the Control Source properties of
these controls?

I'd expect that the course enrollment subform would be a continuous
form bound to tblCourseInfo, with one ROW per course enrolled. Is that
what you mean?

I created a query base on formulas which I use for my reports and forms. On
the reports, it lists all those courses each person took, and total company
assistance for each course, and then on the footer, i put unbound box and use
the formula to add them as grandtotal.....I am just wondering if there is a
way that i can set up something like click a command button, and it will
generate a the result i want such as "Return Anybody who has Grandtotal of
$2000" for 2006"

SELECT TBLEmp.<whatever fields you want>, Sum(tblCost.Cost)
FROM (TblEmp INNER JOIN tblCourseInfo
ON tblEmp.EmpID = tblCourseInfo.EmpID)
INNER JOIN tblCost
ON tblCost.CourseID = tblCourseInfo.CourseID
GROUP BY tblEmp.EmpID
HAVING Sum([tblCost.Cost) > 2000
WHERE Year(tblCourseInfo.CourseDate) = [Enter year:];

will return only those employees whose aggregate cost during the
entered year exceeds 2000 dollars.

John W. Vinson[MVP]

 

[tina]

aha, Gunny, now *you're* in the hot seat! <chortles evilly>

 

[accessuser via AccessMonster.com]

THIS IS WONDERFULLLLLLL!!! It is working exactly the way i wanted. one more
question, to make my administrator user easier in the future, is there a way
that I can set up something and she can change the expression of greater than
or less? The amount can be changed depends on the company. Is there a way
she can change it without going into Query View?


Thank you so much!

I have the following tables;

[quoted text clipped - 8 lines]

CostID (PK)
CourseID (FK)

Ok... those look good...

FrmMain with TblEmp info, FSubCourseInfo has CourseID, which has course 1,
course 2, course 3 etc....,,..and I have FrmCost, after the users input their
Courseinfo in the Subform, there is CmdAddCost, opens up Cost form, and input
the info by using CourseID, so make sure they will link to each other later
on.....

but this isn't communicating to me. What is the Recordsource property
of FSubCourseInfo? Does it have separate Controls for Course1,
Course2, Course3? If so, what are the Control Source properties of
these controls?

I'd expect that the course enrollment subform would be a continuous
form bound to tblCourseInfo, with one ROW per course enrolled. Is that
what you mean?

I created a query base on formulas which I use for my reports and forms. On
the reports, it lists all those courses each person took, and total company

[quoted text clipped - 3 lines]

generate a the result i want such as "Return Anybody who has Grandtotal of
$2000" for 2006"

SELECT TBLEmp.<whatever fields you want>, Sum(tblCost.Cost)
FROM (TblEmp INNER JOIN tblCourseInfo
ON tblEmp.EmpID = tblCourseInfo.EmpID)
INNER JOIN tblCost
ON tblCost.CourseID = tblCourseInfo.CourseID
GROUP BY tblEmp.EmpID
HAVING Sum([tblCost.Cost) > 2000
WHERE Year(tblCourseInfo.CourseDate) = [Enter year:];

will return only those employees whose aggregate cost during the
entered year exceeds 2000 dollars.

John W. Vinson[MVP]