Looking for an Access programmer for a small project...

  • Thread starter Thread starter ***New_But_Learning
  • Start date Start date
N

***New_But_Learning

Hi,

I am a beginner Access user, and I've found I don't have the time to do what
I wanted. Thus, I need to hire someone to do it for me.

I have a punchclock program that stores the employee's info in text files,
with the punch in times seperated by spaces. Thus, employee "Bill Tanner"
has a text file called "Bill Tanner.txt". When I open the text file, this
is how it is recorded:

IN 07/17/2003 15:30
OUT 07/17/2003 18:53
IN 07/24/2003 19:21
OUT 07/24/2003 23:01
IN 07/26/2003 10:15
OUT 07/26/2003 14:21
IN 07/30/2003 16:58
OUT 07/30/2003 21:54
IN 08/12/2003 19:06
OUT 08/12/2003 23:12

(It's all lined up in columns)

I've figured out how to create 30 different tables that are linked to the
text files, thus I have "tblBTanner", with his punch info in different
columns.

But I don't know what to do next. I need to have different reports for
timekeeping, including overtime figured on both 8 hours a day, and 40 hours
a week. I need to be able to calculate payroll based on their wage (I know
I'll need a seperate table with each employee and their wage per hour). I'd
also like summing reports that can easily show the total hours worked by all
employees over a period of time.

If there is an easy way to do this, I would appreciate any comments, so I
could try it myself. I just don't see how it will all fit together.

If someone would like to do it for me, please send a quote to
(e-mail address removed) (remove both y's from the email address). I would
like to keep this under $100. But I'll certainly entertain any suggestions
for more elaborate programming.

Thanks!
 
I've figured out how to create 30 different tables that are linked to the
text files, thus I have "tblBTanner", with his punch info in different
columns.
Click to expand...

That's a spreadsheet design - NOT a relational database design. This
information should be stored in *TWO* tables:

tblEmployees
EmployeeID <SSN, or EmployeeNo, or an Autonumber>
LastName <e.g. Tanner>
FirstName <e.g. Fred>
<other bio information>

tblHours
EmployeeID <whose hours>
InOrOut <maybe a yes/no field, yes for In>
When <date/time field combining both the date and the time>

If TANNER.TXT has 32 records, you'ld have 32 records for Tanner's
EmployeeID in this table; if HASSAN.TXT has 24, she'd have 24 records
and so on. You store data *in tables*, not in Tablenames.
But I don't know what to do next. I need to have different reports for
timekeeping, including overtime figured on both 8 hours a day, and 40 hours
a week. I need to be able to calculate payroll based on their wage (I know
I'll need a seperate table with each employee and their wage per hour). I'd
also like summing reports that can easily show the total hours worked by all
employees over a period of time.
Click to expand...

Can be done with a properly normalized design.
If there is an easy way to do this, I would appreciate any comments, so I
could try it myself. I just don't see how it will all fit together.

If someone would like to do it for me, please send a quote to
(e-mail address removed) (remove both y's from the email address). I would
like to keep this under $100. But I'll certainly entertain any sugg
Click to expand...

<boggle> That's going to come up just a bit short (maybe twentyfold)
for a full-featured payroll application. You may really want to
consider using QuickBooks or one of the many commercially available
turnkey payroll packages.
 
***New_But_Learning said:
Hi,

I am a beginner Access user, and I've found I don't have the time to do what
I wanted. Thus, I need to hire someone to do it for me.

I have a punchclock program that stores the employee's info in text files,
with the punch in times seperated by spaces. Thus, employee "Bill Tanner"
has a text file called "Bill Tanner.txt". When I open the text file, this
is how it is recorded:

IN 07/17/2003 15:30
OUT 07/17/2003 18:53
IN 07/24/2003 19:21
OUT 07/24/2003 23:01
IN 07/26/2003 10:15
OUT 07/26/2003 14:21
IN 07/30/2003 16:58
OUT 07/30/2003 21:54
IN 08/12/2003 19:06
OUT 08/12/2003 23:12

(It's all lined up in columns)

I've figured out how to create 30 different tables that are linked to the
text files, thus I have "tblBTanner", with his punch info in different
columns.
Click to expand...
Do you have any control over the text files?
There are several things you can do that would involve a number of update
queries and append queries that would get the information into one table
where it belongs.
IN and OUT are different and sooner than later you will want a table with
EmpName, InDate, InTime, OutDate, Out time.

This will make calculating hours a bit easier.
 
Back
Top