By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,326 Members | 1,932 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,326 IT Pros & Developers. It's quick & easy.

Creating an Attendance Report

P: n/a
Hi there

I am hoping for a little bit of advice on creating an attendance report.

I work for a company that employees a large number of temp staff and I need
to monitor their attendance.

I currently use excel to manage this job but I am finding it very difficult
to maintain and would really like to move away from excel and have just 1
database.

Has anyone created an attendance related table using access? If you have
how did you do it? I just need some suggestions in what way I should go
about making this as its got me very confused(yes.....that doesn't take
much!!!!)
Any ideas would be great!!

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Start with tables like these:
TblTempEmployee
TempemployeeID
FirstName
LastName
<etc>

TblPosition
PositionID
Position

TblTempEmployment
TempEmploymentID
TempEmployeeID
PositionID
FirstDayOfWork
LastDayOfWork

TblAttendance
AttendanceID
TempEmploymentID
DateWorked
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"spnz via AccessMonster.com" <fo***@nospam.AccessMonster.com> wrote in
message news:fc******************************@AccessMonste r.com...
Hi there

I am hoping for a little bit of advice on creating an attendance report.

I work for a company that employees a large number of temp staff and I need to monitor their attendance.

I currently use excel to manage this job but I am finding it very difficult to maintain and would really like to move away from excel and have just 1
database.

Has anyone created an attendance related table using access? If you have
how did you do it? I just need some suggestions in what way I should go
about making this as its got me very confused(yes.....that doesn't take
much!!!!)
Any ideas would be great!!

--
Message posted via http://www.accessmonster.com

Nov 13 '05 #2

P: n/a
Hi PC Datasheet

Thanks for your suggestion but Im no wiser......

Can you suggest how I could set up these tables?

Thanks again!

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #3

P: n/a
I don't understand what you are asking!

I'm taking from your question that you need serious help. If you send me a
copy of your Excel workbook and a detailed description of how it works, I
will be glad to give you a quote to build the database for you. You will
find my fees are very reasonable and you can be assured you will be well
satisfied working with me.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"spnz via AccessMonster.com" <fo***@AccessMonster.com> wrote in message
news:ae******************************@AccessMonste r.com...
Hi PC Datasheet

Thanks for your suggestion but Im no wiser......

Can you suggest how I could set up these tables?

Thanks again!

--
Message posted via http://www.accessmonster.com

Nov 13 '05 #4

P: n/a

"PC Datasheet" <no****@nospam.spam> schreef in bericht news:zo****************@newsread1.news.atl.earthli nk.net...
I don't understand what you are asking!

I'm taking from your question that you need serious help. If you send me a
copy of your Excel workbook and a detailed description of how it works, I
will be glad to give you a quote to build the database for you. You will
find my fees are very reasonable and you can be assured you will be well
satisfied working with me.


Beware for this sleezy cheater !
This guy seems to be just specializing in advertising and job-hunting in the groups here.
Check out:
http://www.google.com/groups?as_q=co...ng=d&lr=&hl=nl

Arno R

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.