Embedded Objects?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey! I need to embed some kind of object that will change with each record in a database. Here's what i have: In MS ccess 97, i have built a database containing one record for each student who works in our office. What i need: some kind of place where i can record a date and the number of hours s/he logged in tht day. AND i need to keep a running tally. (So i can't just enter values into text field and erase & update them.) I tried putting an Excel worksheet in the form, but even if i got it to work, it didn't change with every record. No mount of linking has fixed the problem. How do i do this? Please help me! And if it's not at all possible, somebody tell me! Plese respond vi e-mail! Thank you!
 
What you need is another table to hold the hours - or better still
start and stop times. This would be part of a one->many relationship.
You would add a new record for each time interval.

For example if your student tabel looks like this...

tblStudent
StudentID - [PK] Long Number
FirstName - Text
LastName - Text

Then your hours worked table might look like this ...

tblHoursWorked
HoursWrkdID - [PK] Long Number
StudentID - [FK] LongNumber
HrsStart - Date/Time
HrsStop - Date/Time


You would link them on StudentID.
Totals/running totals could be easily calculated. No need to embed a
clumsy old spreadsheet.

- Jim
 
Back
Top