anybody not use caculation

To make it really easy, I would suggest you remove the computers from the
users' desks, issue them all pencils, rotary calculators (mechanical is much
more reliable than digital), and green ledger sheets.

They can then hand enter all the data and use the calculators to do the
math. If they need to share the information with other users, then perhaps
you can get your boss to acquire a memograph machine for the office.

"accessuser via AccessMonster.com" wrote:

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

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!!!
Keith Wilby wrote:
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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200612/1

Hi Keith

is there a way to do it in query or has to do in the form and report?
You can do it in any other these.
You can show overall totals, subtotals, totals over a given time, during a
time, between times, compare different totals to projected results, show ....
well you get it.

This is what access does

BUT.....

Please read all the other answers to this post. The main thing - above all
- is to remember that there is a BIG difference between making a database for
yourself or a friend and in producing and developing one for a work
environment where the results matter and, in some cases, people's jobs rely
on what you produce.

Good luck with your project.


--
Buon Natale, Happy Chritmas.

Wayne
Manchester, England.
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.



"accessuser via AccessMonster.com" wrote:

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!!!
Keith Wilby wrote:
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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200612/1

"Wayne-I-M" wrote in message
...

Hi Keith

is there a way to do it in query or has to do in the form and report?

Wasn't me guv!

Keith.

ooops
I will make a new resolution to learn english fully next year - it is a very
silly language and also not to make mistakes - ever - as I seeme to make many
now

\|||||/
o o
+
\_/


--
Buon Natale, Happy Chritmas.

Wayne
Manchester, England.
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.



"Keith Wilby" wrote:

"Wayne-I-M" wrote in message
...

Hi Keith

is there a way to do it in query or has to do in the form and report?

Wasn't me guv!

Keith.

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


"Wayne-I-M" wrote in message
...
ooops
I will make a new resolution to learn english fully next year - it is a
very
silly language and also not to make mistakes - ever - as I seeme to make
many
now

\|||||/
o o
+
\_/


--
Buon Natale, Happy Chritmas.

Wayne
Manchester, England.
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.



"Keith Wilby" wrote:

"Wayne-I-M" wrote in message
...

Hi Keith

is there a way to do it in query or has to do in the form and report?

Wasn't me guv!

Keith.

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

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


--

Lynn Trapp
Microsoft MVP (Access)
www.ltcomputerdesigns.com

On Mon, 18 Dec 2006 01:02:09 -0800, "'69 Camaro"
AM wrote:

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

Looked in a mirror recently, Gunny? g

John W. Vinson[MVP]

On Mon, 18 Dec 2006 14:13:20 GMT, "accessuser via AccessMonster.com"
u28669@uwe wrote:

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]

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!

John Vinson wrote:
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]

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200612/1