i have a textbox in a form. Where i want it to calculate the total of hours for different employees in different month.
when i use "=sum([hour])" it gives the the total of all employee in all of the monthes.
and when i use Dsum as " = DSum( "[Hour]", "[tablename]", "[MonthID]" =1)", it gives me the total of all employee in January.
my question is, what should i do to make it only calculate the total hour of only the one specific employee and one specific month.
3  5020 
i have a textbox in a form. Where i want it to calculate the total of hours for different employees in different month.
when i use "=sum([hour])" it gives the the total of all employee in all of the monthes.
and when i use Dsum as " = DSum( "[Hour]", "[tablename]", "[MonthID]" =1)", it gives me the total of all employee in January.
my question is, what should i do to make it only calculate the total hour of only the one specific employee and one specific month.
= DSum( "[Hour]", "[tablename]", "[MonthID]" =1 AND "[EmpID]" =1)
The criteria of the DSUM works just like a Where clause without "Where".
hi, thanks for replying, jaxjagfan..
but, it still didn't solve my problem, i don't think i explained it clear enough...
the problem is that, this mainform has a subfrom. the main form contains employeeID, and the subform is where employee can enter their own hours and monthes....and on the main from footer, i have this textbox, where i want it calculate the total hours for each month. So, if i use " empID=1" , it will only give me value for EmployeeI , not total hours to the related employee.
i tried to make a query, it gives me the right answer.(where shows the diffeerent month total hours to related employee name). However, i dno't know how to make the result to show on my mainform ?
Do you know hwo can i solve that? Thanks.
= DSum( "[Hour]", "[tablename]", "[MonthID]" =1 AND "[EmpID]" =1)
The criteria of the DSUM works just like a Where clause without "Where".
hi, thanks for replying, jaxjagfan..
but, it still didn't solve my problem, i don't think i explained it clear enough...
the problem is that, this mainform has a subfrom. the main form contains employeeID, and the subform is where employee can enter their own hours and monthes....and on the main from footer, i have this textbox, where i want it calculate the total hours for each month. So, if i use " empID=1" , it will only give me value for EmployeeI , not total hours to the related employee.
i tried to make a query, it gives me the right answer.(where shows the diffeerent month total hours to related employee name). However, i dno't know how to make the result to show on my mainform ?
Do you know hwo can i solve that? Thanks.
DSum( "[Hour]", "[tablename]", "[MonthID]" =1 AND "[EmpID]" = & Me.FormEmployeeIDControl)
Should be something like that. When you sum on month just remember that is All Month 1's or all January's. Make sure you include Month Year combinations at a minumum to get correct totals.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Rolan |
last post by:
I'm using Access 97 and need some assistance in sorting out a proper
DSum expression, or maybe even DCount might be an alternative. I have
tried numerous combinations, but with no apparent success....
|
by: Dalan |
last post by:
I seemed to be having problems with structuring the use of NZ with a
DSum expression. Having tried numerous variations of the expression
without success, I'm asking for assistance.
First some...
|
by: Alex |
last post by:
Acc 97
Hi,
I have the following in my query which works well if it is all set to
numbers on table design.
But what I want to do is where it states MC (short for machine name) use the
actual...
|
by: John Baker |
last post by:
Hi:
I have a form, and wish to show on the form the current total for a single field on a
table. I have set this up thus: =DSum(,!) in an unbound
text field. These are correct field and table...
|
by: Mark Reed |
last post by:
All,
I have never used this function before and am not sure it what I need.
Just to clarify, I have a report based on a query which has amoungst other
field, wk, parea & packs_req. What I am...
|
by: beppe005 |
last post by:
I would like to calculate a total for all the field with the same
in a query.
I don't know how to set the "criteria" for this dsum function, it should be
something like = but it doesn't make...
|
by: gbb0330 |
last post by:
Hi All
i am trying to calculate Quantity on hand in a unbound textbox in a
form with a subform
QonHand=Qreceived - TotalQSold
TotalQsold=QsoldOnEbay+QsoldThruOtherChannels
here is my...
|
by: potassium flower |
last post by:
I am trying to create a food order system for a restaurant.
I have tried using both the DSum and Sum functions to calculate the total cost of an order. The total cost is a textbox on the form...
|
by: danielgoss |
last post by:
Hi
I have a report that has loads of textboxes that calculate things based on the value on another textbox in the report. I have put a hidden textbox on my report that gets its value from an...
|
by: majapa |
last post by:
To start, here is my DSum expression:
Develop: Nz(DSum(". & "] + . & "]","CSO","='Ability to Develop'")*-1,0)
I actually have 4 of these, each one with a different option for .
For more context,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
