•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 427,776 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,725 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 821 | Replies: 0
 |
•
•
Join Date: May 2007
Posts: 4
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hello please help me to calculate this one:
I have a table containing this fields (name, project done, hours consumed)
example:
this is a table of a timesheet
my problem is how to get the total no. of hours of only "A'" or only "B"
for example: I want to get the total hours of "A"
5+8+6=19 hours then multiply it to 10 so that I can get the total salary of "A" which is 10X19=190
then the 190 should appear to the textbox of "A"
example:
A's Salary is : [190] <--- this is a text box inside a form
...
Please help me please
I'm using Access 2003
THANKS and GODBLESS
I have a table containing this fields (name, project done, hours consumed)
example:
this is a table of a timesheet
- ---------------------------------------------------------------------------
- | NAME | PROJECT DONE | HOURS CONSUMED |
- --------------------------------------------------------------------------
- | A | 1 | 5 |
- | B | 2 | 10 |
- | B | 3 | 12 |
- | A | 2 | 8 |
- | D | 1 | 9 |
- | D | 3 | 3 |
- | A | 4 | 6 |
my problem is how to get the total no. of hours of only "A'" or only "B"
for example: I want to get the total hours of "A"
5+8+6=19 hours then multiply it to 10 so that I can get the total salary of "A" which is 10X19=190
then the 190 should appear to the textbox of "A"
example:
A's Salary is : [190] <--- this is a text box inside a form
...
Please help me please
I'm using Access 2003
THANKS and GODBLESS
==========================
THANK YOU AND GODBLESS !!!
FROM PLAYAGAIN :)
==========================
|
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- How can i deledet and update from table ??????? (PHP)
- Copying table from one mdb to another (ASP)
- Need help with HTMl Table echoing? (PHP)
- Table of Contents Script (Java)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Matching records from a query to a table records
- Next Thread: How to open pdf documents from a Microsoft Access Form and Creation of Browser
