Displaying a group of records

  • Thread starter Thread starter jrt121
  • Start date Start date
J

jrt121

I'm not sure if this is the proper group to place this in, so I
apologize if it should be elsewhere.

Using Excel, I have a workbook that I use to calculate total time on
duty for employees during a 6 and/or 7 day period. My question is: is
there a way to do something like this in Access? I propose to create a
table containing the Name, date and on duty time for that date. Perhaps
I'm asking too much of Access, or perhaps I'm going about my task the
wrong way.

TIA

Justin
 
hi,
no you have the right play.
create you table with your 3 fields.
you can even import from your excell file.
then create the form with the wizard. it will do
everything for you.
if you don't like the way the wizard did it, you can
delete the form and try another style.
good luck
 
Access is the correct application to accomplish what you want, but you will
need to closely examine your data structure (normalzation)

Note:: People is People and should not be mixed with work record.

here is a bare bones example:
People (table)

PeopleID (number, integer), autoincrement, key field
lastname
firstname
othere stuff relating to the person

WorkRecord (table)
WorkID (number, integer), autoincrement, key field
PeopleID (number, integer) -- ties this table to the people table
StartTime (date/time)
EndTime (date/time)


SQL Query:

SELECT People.PeopleID, People.LastName, People.FirstName,
Sum(DateDiff("h",[TimeStart],[timeend])) AS Hours
FROM People INNER JOIN WorkRecord ON People.PeopleID = WorkRecord.PeopleID
WHERE (((WorkRecord.TimeEnd) Between [dayStart] And [dayend]))
GROUP BY People.PeopleID, People.LastName, People.FirstName;

Hope this helps

Ed Warren
 
Back
Top