Creating an Attendance Report

[spnz via AccessMonster.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

[PC Datasheet]

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

[spnz via AccessMonster.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

[PC Datasheet]

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

[StopThisAdvertising]

"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