473,324 Members | 2,239 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

New Table?

Hello everyone, I have a question. I have two tables Employees which holds all the employee information with the following fields:
EmployeeID - Text (Primary)
DepartmentCode - Text
DateOfHire - Date/Time
FirstName - Text
LastName - Text
Seniority # - Number
WorkDays - Number

I also have an activityLog table which has the following fields:
ActivityLogID - Autonumber (Primary)
EmployeeID - Text (Relates to EmployeeTable)
ActivityType - Text
ActionDate - Date/Time (This is what determines what day the occurance occur)
EndingDate - Date/Time (365 days + Action Date)
DaysOff - Number (Difference)
ReasonCode - Text (Relates to ReasonCode Table - has the points etc.)
Points - Number (Points received)
SickDaysUsed - Number
VacationDayUsed - Number

My question is how to generate a team members perfect attendance by month calculating and keeping a count of previous months until they receive a point? Should I make another table name Perfect attendance and have append and delete queries run each month? Or should I just try and query out the information through my ActivityLog Table?
Thank you
Sep 10 '08 #1
3 1449
NeoPa
32,556 Expert Mod 16PB
...
My question is how to generate a team members perfect attendance by month calculating and keeping a count of previous months until they receive a point?
...
The supporting information is good as far as it goes, but the question itself leaves me confused. I look around for clues in the punctuation, but there is none. I also look for explanations for some of the terms and concepts introduced (perfect attendance; points; Monthly grouping; etc). No joy there either. Remember, I only know what you tell me about your setup. There are so many different possibilities that I can't assume you're thinking any particular way.

I can't help without understanding the problem (in enough detail) I'm afraid.
Sep 11 '08 #2
The supporting information is good as far as it goes, but the question itself leaves me confused. I look around for clues in the punctuation, but there is none. I also look for explanations for some of the terms and concepts introduced (perfect attendance; points; Monthly grouping; etc). No joy there either. Remember, I only know what you tell me about your setup. There are so many different possibilities that I can't assume you're thinking any particular way.

I can't help without understanding the problem (in enough detail) I'm afraid.
I'm sorry, I was in kind of a hurry from work when I typed this up. I also have another table called ReasonCodes and it has the following fields:
ReasonCode - Text (Primary)
ReasonDescription - Text
PointValue - Number
SickDaysUsed - Number
VacationDaysUsed - Number
AgainstPA - Yes/No (Against Perfect Attendance)

Now how this works is an employee is awarded perfect attendance for each consecutive month they receive perfect attendance, any reason code record that isn't against PA. Whoever made this database, the Perfect Attendance isn't calculating correctly. The person who made this has a table called PAtbl and it has the following fields:
PAID - AutoNumber (Primary)
EmployeeID - Text (Relates to the Employee Table)
TheMonth - Number
TheYear - Number
PA - Yes/No (Perfect Attendance)
Consecutive - Number

So the person who created it has queries that append and delete when the "perfect attendance" is ran, however, it does not calculate correctly. So rather than going through all the queries and code that he inserted to calculate I thought I would try to make my own and I am user if it's easier to build?
Sep 11 '08 #3
NeoPa
32,556 Expert Mod 16PB
My problem here, is that while you explain various things previously missed out, you still don't tell me the logic of what you're trying to do.
Now how this works is an employee is awarded perfect attendance for each consecutive month they receive perfect attendance, any reason code record that isn't against PA.
This doesn't tell me much other than perfect attendance = perfect attendance.

If you do choose to post a clear question with all the information I need, then please try to put everything in a single post. Trawling through multiple posts to put the question together like a jig-saw is not something I will be very keen on doing.

Always remembering of course, that I will only know what you tell me about your particular database and setup.
Sep 14 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Gaz | last post by:
Hi, I need to have a table nested within another table. The tables are alongside each other visually speaking, and the nested table (on the right) can vary in size. My problem is that when the...
61
by: Toby Austin | last post by:
I'm trying to replace <table>s with <div>s as much as possible. However, I can't figure out how to do the following… <table> <tr> <td valign="top" width="100%">some data that will...
3
by: Terrence Brannon | last post by:
I don't know what Postgres considers a relation and had no intention of creating one when piping my schema to it... I always DROP TABLE before CREATE TABLE, so here are the ERRORS emitted when...
4
by: maricel | last post by:
I have the following base table structure - DDL: CREATE TABLE "ADMINISTRATOR"."T1" ( "C1" INTEGER NOT NULL ) IN "TEST_TS" ; ALTER TABLE "ADMINISTRATOR"."T1" ADD PRIMARY KEY
4
by: Simone Battagliero | last post by:
I wrote a program which inserts and finds elements in an hash table. Each element of the table is a dinamic list, which holds all elements having the same hash value (calculated by an int...
117
by: phil-news-nospam | last post by:
Is there really any advantage to using DIV elements with float style properies, vs. the old method of TABLE and TR and TD? I'm finding that by using DIV, it still involves the same number of...
76
MMcCarthy
by: MMcCarthy | last post by:
Normalisation is the term used to describe how you break a file down into tables to create a database. There are 3 or 4 major steps involved known as 1NF (First Normal Form), 2NF (Second Normal...
7
by: Kamal | last post by:
Hello all, I have a very simple html table with collapsible rows and sorting capabilities. The collapsible row is hidden with css rule (display:none). When one clicks in the left of the...
5
by: wugon.net | last post by:
question: db2 LUW V8 UNION ALL with table function month() have bad query performance Env: db2 LUW V8 + FP14 Problem : We have history data from 2005/01/01 ~ 2007/05/xx in single big...
5
by: jrod11 | last post by:
hi, I found a jquery html table sorting code i have implemented. I am trying to figure out how to edit how many colums there are, but every time i remove code that I think controls how many colums...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.