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 |
#11
|
|||
|
|||
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 |
#12
|
|||
|
|||
anybody not use caculation
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 |
#13
|
|||
|
|||
anybody not use caculation
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 |
#14
|
|||
|
|||
anybody not use caculation
"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. |
#15
|
|||
|
|||
anybody not use caculation
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. |
#16
|
|||
|
|||
anybody not use caculation
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. |
#17
|
|||
|
|||
anybody not use caculation
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 |
#18
|
|||
|
|||
anybody not use caculation
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] |
#19
|
|||
|
|||
anybody not use caculation
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] |
#20
|
|||
|
|||
anybody not use caculation
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 |
Thread Tools | |
Display Modes | |
|
|