Need Help with Table Design

  • Thread starter Thread starter tmdrake
  • Start date Start date
T

tmdrake

I have a Staff table, where a staff memeber can work on one or many Projects.

I am not sure how to construct a table to show the weeks worked (example:
Week Ending 12/18/2007; the column heading) and how many hours worked. How
do I design the table so that when I create a form it prompts the user to
enter Start and End Date and displays the information for that Staff member
using the dates entered as the time frame.

Help is greatly appreciated

Thanks
 
You're not giving us enough info. Or making much sense.

1st, make sure your table structure is normalised. As a newbie, I kept
putting off normalisation, thinking it was only something advanced users
needed to know. It isn't. You can't create tables with the same structure
you'd give them in a spreadsheet. As a general rule Access tables should be
long and thin.

2nd. We need to know what data your table stores, wheather you want to do
calculations on it, and what format you want it presented in.

3rd. Then we can work out how best to make this happen (forms, queries or
reports)

4th. Learn what's ment by 'table'. You need to clarify when you mean table as
a data structure and when you mean it as a format for displaying your data.
 
Thanks JEA

I sorry I'm not making sense, this only goes to show how confused I really am.

1) I'm not sure what you mean my normalisation. I am using a table as a
data source.
2) This information stored on the table is the ProjectID (text),
DisciplineName (text), SectionNumber (number), LastName (text), FirstName
(text), Division (text), Est Project Start Date (date), EstProject End date
(date), 12/1/2007 thru 03/29/2008 (column heading, number of hours worked in
the fields below the appropriate week's heading). These are the column
headings.

As stated before, I have a form with a subform. On the form the user can
make one or more selections from the 4 comoboxes. Once the selection is made
the results display in the subform.

On the subform, when you double click on the LastName then another form pops
up displaying the information from the fields above.

What I am trying to do is to narrow down the information displayed on the
pop up form (the form that pops up once you double click on the LastName) to
a specific time frame; instead of showing all the weeks from
12/1/2007-03/29/2008. I would like for the user to Enter a Start Date and
End Date to show the hours worked for those specific weeks.

Hopefully you can better understand this verision. The more I type this the
more I confuse myself.

Thanks so much for you help.
 
1) I'm not sure what you mean my normalisation. I am using a table as a
data source.
2) This information stored on the table is the ProjectID (text),
DisciplineName (text), SectionNumber (number), LastName (text), FirstName
(text), Division (text), Est Project Start Date (date), EstProject End date
(date), 12/1/2007 thru 03/29/2008 (column heading, number of hours worked in
the fields below the appropriate week's heading). These are the column
headings.
Click to expand...

If by "column headings" you mean fieldnames - you have a Spreadsheet, not a
relational database table!

You need another table with a link to this table (ProjectID), a date field
(the week ending date or week beginning date), and a number field for hours
worked. Rather than one *field* per week, you would have one *record* per
week.

John W. Vinson [MVP]
 
Will I need to created a record for each week on each staff memeber? Example.
Staff - Allen
Work 12 weeks on Project PWD, will Allen have a record for each week for
this project?

Thanks very much
 
Will I need to created a record for each week on each staff memeber? Example.
Staff - Allen
Work 12 weeks on Project PWD, will Allen have a record for each week for
this project?
Click to expand...

If you need to keep track of how many hours Allen worked in each week... of
course.

You'ld typically use a continuous Subform to do so, so you can see one row of
data per week, with multiple weeks visible on the form.

John W. Vinson [MVP]
 
Thanks I will try this.
--
tmdrake


John W. Vinson said:
If you need to keep track of how many hours Allen worked in each week... of
course.

You'ld typically use a continuous Subform to do so, so you can see one row of
data per week, with multiple weeks visible on the form.

John W. Vinson [MVP]
Click to expand...
 
Please look up normalisation. It's sort of a set of rules on how you should
store your data. It's quite heavy reading but well worth it. I spent weeks
trying to get a database to work , everyone was telling me to normalise my
tables but I kept putting it off as it seemed something for the advanced user.
In the end I had to bin weeks of work and start from scratch with a
normalised table structure.
There's loads of stuff on the net about it. Just google it. I can't remember
which site I used, but don't let the complexity of some site's explanation
put you off (Wikipedia's entry is scarily complex), keep searching for a
simple explanation. It'll save you time in the long run.
Thanks JEA

I sorry I'm not making sense, this only goes to show how confused I really am.

1) I'm not sure what you mean my normalisation. I am using a table as a
data source.
2) This information stored on the table is the ProjectID (text),
DisciplineName (text), SectionNumber (number), LastName (text), FirstName
(text), Division (text), Est Project Start Date (date), EstProject End date
(date), 12/1/2007 thru 03/29/2008 (column heading, number of hours worked in
the fields below the appropriate week's heading). These are the column
headings.

As stated before, I have a form with a subform. On the form the user can
make one or more selections from the 4 comoboxes. Once the selection is made
the results display in the subform.

On the subform, when you double click on the LastName then another form pops
up displaying the information from the fields above.

What I am trying to do is to narrow down the information displayed on the
pop up form (the form that pops up once you double click on the LastName) to
a specific time frame; instead of showing all the weeks from
12/1/2007-03/29/2008. I would like for the user to Enter a Start Date and
End Date to show the hours worked for those specific weeks.

Hopefully you can better understand this verision. The more I type this the
more I confuse myself.

Thanks so much for you help.
You're not giving us enough info. Or making much sense.
Click to expand...
[quoted text clipped - 24 lines]
Click to expand...
 
Back
Top