Table/Forms Design Question

Damien,

1. You can change the tblJob to what you posted IF you only care about
numerical values.
2. Yes, you can enter data in tblCrewType
3. Yes, you chould be able to make a form similar to your Excel
spreadsheet.
4. As for getting rid of the Date field, you indicated in your original
posting you wanted Daily reports. How are you going to do this without
date? I am also thinking you will need to add jCompleted (Yes?No) field to
your tblJobs.
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
To answere your questions:
1. The values will be entered by a user. Depending on a day how many
Forman
he had under him, how many workers and laborers he was responsible for.
2. Worker and Crew are the same thing. (not to be confused with
Foreman/Workers/Laborers column. Its different Workers).
Steve just sugested to replace Crew with Worker to avoid confusion.

So the tables are very simple. There is no Date required.

tblCrew
cCrewID (PK- Auto #)
cFName
cLName
cCrewTypeID (is he a carpenter, laborer, lather or Ironworker. Linked to
table below. Probably Drop Down box in a form)

tblCrewType
ctID (PK - Auto#)
ctName (carpenter, laborer, lather or Ironworker. Can I enter them now
since
they are going to be Default?)

tblJobs
jJobID (PK - Auto #)
jJobDescription (Foreman - Workman - Laborer) (Thats all, only 3)
((((
If I only care about the Numerical Values for how many
Foreman-Workman-Laborer) each of the Crew had. Can I do this?
tblJobs
jJobID (PK - Auto #)
jNumberOfForemans (1,2,3,4 or whatever it will be.)
jNumberOfWorkman ( same as above)
jNumberOfLaborers (same as above)
)))

tbJobDetail
jdJobDetailID (PK - Auto #)
jdJobID
jdCrewID

With these tables can I make a Form that will resemble the excel sheet?

Thank You

"Gina Whipp" wrote:

Damien,

I have a couple of questions, at the bottom, BUT below is what I think
you
need so far...

tblCrew
cCrewID (PK-Autonumber)
cFirstName
cLastName
cCrewTypeID
etc...

tblCrewTypes
ctCrewTypeID
ctName
etc...

tblJobs
jJobID
jDate
jJobDescription
etc...
other job fields you might need

tblJobDetail
jdJobDetailID
jdJobID
jdCrewID

1. Where are you getting the numbers (values) from? Are you getting
that
from who is assigned to the Job?
2. The explanation you provided below confuses me as to the difference
between Worker and Crew, please explin?
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
But you see what I am trying to create, right? Under colums Crews on
that
excell are names of Workers, they are in TblWorkers. Column D which is
Carpenters, Laborers etc are the WorkerType, they are in TblWorkerType
which
will be linked to TblWorkers. Next we have columns E,F,G which is
Foreman-Workman-Laborers, They are under TblCrew.

Now where and how can I put the Values that are under
Foreman-Workman-Laborer for each worker?

Also should I do the totals is a querie and likn it to a form or do a
textbox on a form and write the equation there?

"Steve" wrote:

Bob Fox is not in your Excel example to see what you mean.

Steve


"Damian" wrote in message
...
I don't think I need TblForeman since Foreman field will not have
name,
it
only has a number. Like, Bob Fox(WorkerID) will have 2 Foreman(Crew
ID).
Thats what my question is, how do I create my tables to represent
this.
my TblCrew has 2 fields
CrewID
CrewName
This will only allor you to input the Crew name like Foreman or
worken
or
laborer. (these are the only 3) so should there be another CrewCount
in
this
Tbl? or should the Count be somewhere else?
Look at this excell (
http://img21.imageshack.us/img21/6924/excellsample.png )
This is what I am trying to create.

But I am little confused on how to link them in a form and create
Good,
Normalized Tables so there is no data repetition as I had in the
beginning.

"Steve" wrote:

You added more to the description of your database and now It seems
you
need
to modify your tables again! Consider:

TblForeman
ForemanID
ForemanFName
ForemanLName
other foreman fields you might need

TblDailyJob
DailyJobID
DailyJobDate
DailyJobDescription
ForemanID
other job fields you might need

TblDailyJobWorker
DailyJobWorkerID
DailyJobID
WorkerID

Keep previous TblWorkerType and TblWorker. Delete TblCrew and
TblCrewWorker.
You can get the names in a "crew" by getting all the workers on a
specific
daily job.

Steve


"Damian" wrote in message
...
Great advice. I renamed the tables and I think You are right. It
will
avoid
confusion.
So far I have this:
( http://img263.imageshack.us/img263/1...ellsample2.png )
Image for easier view and review.

What my goal is:
To create a form for a user which has Defined fields for
WorkerType,
Underneeth Worker Name, and across CrewName all there because
there
are
only
handfull of guys for each WorkerType.

The User will input only a number of CrewName he/she had for that
day..
So
if WorkenName had 1 Formen, 2 Workers and 4 Laborers under
him/her.
She
would
only enter 1 , 2 , 4 under her row for each CrewName. Then have
fields
for
totaling each thing automatically. Is this all passible with a
form
or
do
I
have to do the totals as a querie and then create a summary
report?

Am I making sense? The first excell image I think explains it
very
nice
what
I mean.

Thanks Guys for helping me with this.

"Steve" wrote:

Hello Damian,

Your tables are still incorrect. To start, how about for clarity
naming
the
people Workers. The naming a group of workers Crew.

TblWorkerType
WorkerTypeID
WorkerType

TblWorker
WorkerID
WorkerFName
WorkerLName
WorkerTypeID

TblCrew
CrewID
CrewName for identifying different crews

TblCrewWorker
CrewWorkerID
CrewID
WorkerID

You can count the types of workers in a crew in a totals query
that
includes
all the above tables on the fly.


Steve




"Damian" wrote in message
...
Made a mistake. Is there an Edit button here? hmm

Correction on the Tables:
So Far I have 3 Tables:

Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews
Type
Table
so
you can choose from drop down menu.

Crews Data
t_CrewDataID autoNumber PK
t_CrewDataType will be Foreman, Workman, Laborer

Crews Type
t_CrewDetailID autoNumber
t_CrewDetailType will be Carpenter, Surveyor, Laborman

Sorry


"Damian" wrote:

Great Help, thanks to all for info and great links. I'm
starting
to
get
the
Big Picture now.
The only thing I am confused is how will I buld a Form for
the
guys
to
fill
out.
Maybe I should explain what I want to accomplish here.

So Far I have 2 Tables:
Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Workman - Foreman or Laborer Linked from Crews
Data
Table

Crews Data
t_CrewsDataID autoNumber PK
t_CrewsDataType will be Foreman, Workman, Laborer

(Now the data Value that you mentioned 1 , 3 , 2 is the
amount
of
Foreman/Workman/Laborer each Crew had. This field is to be
inserted
by
the
user. so should I still have a DataValue field in my Crews
Data
table
when it
will be different for every t_CrewID and every T_CrewsID will
have
all
t_CrewsDataTypes?)
I have an excell for this but I want to create a databaseto
do
this. I
took
a screenshot of the excell so you can understand it and help
me
better.
(Hope
is ok to post links here like these, if not I am sorry)
(http://img21.imageshack.us/img21/6924/excellsample.png)

Thanks Again




"John W. Vinson" wrote:

On Thu, 23 Jul 2009 13:36:01 -0700, Damian

wrote:

I am Trying to create Daily Reports for my company.
I created tables for Carpenters, Laborers, Surveyors,
Ironworkers
etc.
Each of these has fields *_Name, #ofForeman, #ofWorkers,
#ofLaborers.
ex.
"Carpenters Table
CarpentersName Foreman Worekman Laborer
Joe 2 1
5
Bill 1 5
2
"
"Laborers Table
LaborersName Foreman Worekman Laborer
Frank 1 1
0

Your Excel worksheet is confusing! In Laborers, is Jack Pratas a foreman? If
not, why does he have two foreman? Crews are typically defined as a group of
workers under one foreman.

Steve


"Damian" wrote in message
...
But you see what I am trying to create, right? Under colums Crews on that
excell are names of Workers, they are in TblWorkers. Column D which is
Carpenters, Laborers etc are the WorkerType, they are in TblWorkerType
which
will be linked to TblWorkers. Next we have columns E,F,G which is
Foreman-Workman-Laborers, They are under TblCrew.

Now where and how can I put the Values that are under
Foreman-Workman-Laborer for each worker?

Also should I do the totals is a querie and likn it to a form or do a
textbox on a form and write the equation there?

"Steve" wrote:

Bob Fox is not in your Excel example to see what you mean.

Steve


"Damian" wrote in message
...
I don't think I need TblForeman since Foreman field will not have name,
it
only has a number. Like, Bob Fox(WorkerID) will have 2 Foreman(Crew
ID).
Thats what my question is, how do I create my tables to represent this.
my TblCrew has 2 fields
CrewID
CrewName
This will only allor you to input the Crew name like Foreman or worken
or
laborer. (these are the only 3) so should there be another CrewCount in
this
Tbl? or should the Count be somewhere else?
Look at this excell (
http://img21.imageshack.us/img21/6924/excellsample.png )
This is what I am trying to create.

But I am little confused on how to link them in a form and create Good,
Normalized Tables so there is no data repetition as I had in the
beginning.

"Steve" wrote:

You added more to the description of your database and now It seems
you
need
to modify your tables again! Consider:

TblForeman
ForemanID
ForemanFName
ForemanLName
other foreman fields you might need

TblDailyJob
DailyJobID
DailyJobDate
DailyJobDescription
ForemanID
other job fields you might need

TblDailyJobWorker
DailyJobWorkerID
DailyJobID
WorkerID

Keep previous TblWorkerType and TblWorker. Delete TblCrew and
TblCrewWorker.
You can get the names in a "crew" by getting all the workers on a
specific
daily job.

Steve


"Damian" wrote in message
...
Great advice. I renamed the tables and I think You are right. It
will
avoid
confusion.
So far I have this:
( http://img263.imageshack.us/img263/1...ellsample2.png )
Image for easier view and review.

What my goal is:
To create a form for a user which has Defined fields for WorkerType,
Underneeth Worker Name, and across CrewName all there because there
are
only
handfull of guys for each WorkerType.

The User will input only a number of CrewName he/she had for that
day..
So
if WorkenName had 1 Formen, 2 Workers and 4 Laborers under him/her.
She
would
only enter 1 , 2 , 4 under her row for each CrewName. Then have
fields
for
totaling each thing automatically. Is this all passible with a form
or
do
I
have to do the totals as a querie and then create a summary report?

Am I making sense? The first excell image I think explains it very
nice
what
I mean.

Thanks Guys for helping me with this.

"Steve" wrote:

Hello Damian,

Your tables are still incorrect. To start, how about for clarity
naming
the
people Workers. The naming a group of workers Crew.

TblWorkerType
WorkerTypeID
WorkerType

TblWorker
WorkerID
WorkerFName
WorkerLName
WorkerTypeID

TblCrew
CrewID
CrewName for identifying different crews

TblCrewWorker
CrewWorkerID
CrewID
WorkerID

You can count the types of workers in a crew in a totals query that
includes
all the above tables on the fly.


Steve




"Damian" wrote in message
...
Made a mistake. Is there an Edit button here? hmm

Correction on the Tables:
So Far I have 3 Tables:

Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews Type
Table
so
you can choose from drop down menu.

Crews Data
t_CrewDataID autoNumber PK
t_CrewDataType will be Foreman, Workman, Laborer

Crews Type
t_CrewDetailID autoNumber
t_CrewDetailType will be Carpenter, Surveyor, Laborman

Sorry


"Damian" wrote:

Great Help, thanks to all for info and great links. I'm starting
to
get
the
Big Picture now.
The only thing I am confused is how will I buld a Form for the
guys
to
fill
out.
Maybe I should explain what I want to accomplish here.

So Far I have 2 Tables:
Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Workman - Foreman or Laborer Linked from Crews Data
Table

Crews Data
t_CrewsDataID autoNumber PK
t_CrewsDataType will be Foreman, Workman, Laborer

(Now the data Value that you mentioned 1 , 3 , 2 is the amount
of
Foreman/Workman/Laborer each Crew had. This field is to be
inserted
by
the
user. so should I still have a DataValue field in my Crews Data
table
when it
will be different for every t_CrewID and every T_CrewsID will
have
all
t_CrewsDataTypes?)
I have an excell for this but I want to create a databaseto do
this. I
took
a screenshot of the excell so you can understand it and help me
better.
(Hope
is ok to post links here like these, if not I am sorry)
(http://img21.imageshack.us/img21/6924/excellsample.png)

Thanks Again




"John W. Vinson" wrote:

On Thu, 23 Jul 2009 13:36:01 -0700, Damian

wrote:

I am Trying to create Daily Reports for my company.
I created tables for Carpenters, Laborers, Surveyors,
Ironworkers
etc.
Each of these has fields *_Name, #ofForeman, #ofWorkers,
#ofLaborers.
ex.
"Carpenters Table
CarpentersName Foreman Worekman Laborer
Joe 2 1
5
Bill 1 5
2
"
"Laborers Table
LaborersName Foreman Worekman Laborer
Frank 1 1 0
"
And so on (you get the picture)

Now are those tables Normalized? I know I am repeating
Foreman,Workman
&
Laborer in each one of them but each of these tables has
different
Names and
different quantaties of people.

I'd change your design completely. Putting data (the type of
worker)
in
a
tablename or a fieldname is simply WRONG DESIGN.

Workers
WorkerID Primary Key, perhaps an autonumber
WorkerName (I'd actually use LastName and FirstName as
separate
fields
WorkerType e.g. Carpenter, Laborer, Surveyor, ...

WorkerData
WorkerID link to Workers
DataType e.g. "Foreman", "Laborer"
DataValue your 2, 1, 5 etc., whatever they mean


I created a form for Carpenters - A tabular form so I see All
names
for each
Carpenter in seperate box and next to them their
Foreman/Workman/Laborer.
I also included a total column at the end which adds up each
row. I
can edit
the fields each day and the total is changing. (thats good)

The problem is I have to create a Form for Each Table
seperately.
Can I put Table CArpenter/ Laborer/ etc.. into one form and
be
able
to
view
it and edit like I can the single Carpenters Form? I cant
seem
to
make
it
work.

Im reading all these access books and I cant find the answers
I
am
looking
for anywhere.

I also created a Querie that sum up all Foreman for each Name
each
workman
for each name and so on. Plus a final total Column which sums
up
everyone. It
works great, BUT when I try to make it show up on the Form I
cant.
I
can do
it as a footer but it does not automatically update when I
change
the
values.
I have to close it and come back in. Why is that?

I know I am asking a lot and I hope you guys can help me.
Thank you

No he is not a foreman. The names that are under Crews are like the MAIN GUYS
and they have Foremans/workers/ and Laborers under them. We do not care what
the names of them are, JUST how many are under him.

SO Jack Prates has 2 formens and 4 workers under him.

"Steve" wrote:

Your Excel worksheet is confusing! In Laborers, is Jack Pratas a foreman? If
not, why does he have two foreman? Crews are typically defined as a group of
workers under one foreman.

Steve


"Damian" wrote in message
...
But you see what I am trying to create, right? Under colums Crews on that
excell are names of Workers, they are in TblWorkers. Column D which is
Carpenters, Laborers etc are the WorkerType, they are in TblWorkerType
which
will be linked to TblWorkers. Next we have columns E,F,G which is
Foreman-Workman-Laborers, They are under TblCrew.

Now where and how can I put the Values that are under
Foreman-Workman-Laborer for each worker?

Also should I do the totals is a querie and likn it to a form or do a
textbox on a form and write the equation there?

"Steve" wrote:

Bob Fox is not in your Excel example to see what you mean.

Steve


"Damian" wrote in message
...
I don't think I need TblForeman since Foreman field will not have name,
it
only has a number. Like, Bob Fox(WorkerID) will have 2 Foreman(Crew
ID).
Thats what my question is, how do I create my tables to represent this.
my TblCrew has 2 fields
CrewID
CrewName
This will only allor you to input the Crew name like Foreman or worken
or
laborer. (these are the only 3) so should there be another CrewCount in
this
Tbl? or should the Count be somewhere else?
Look at this excell (
http://img21.imageshack.us/img21/6924/excellsample.png )
This is what I am trying to create.

But I am little confused on how to link them in a form and create Good,
Normalized Tables so there is no data repetition as I had in the
beginning.

"Steve" wrote:

You added more to the description of your database and now It seems
you
need
to modify your tables again! Consider:

TblForeman
ForemanID
ForemanFName
ForemanLName
other foreman fields you might need

TblDailyJob
DailyJobID
DailyJobDate
DailyJobDescription
ForemanID
other job fields you might need

TblDailyJobWorker
DailyJobWorkerID
DailyJobID
WorkerID

Keep previous TblWorkerType and TblWorker. Delete TblCrew and
TblCrewWorker.
You can get the names in a "crew" by getting all the workers on a
specific
daily job.

Steve


"Damian" wrote in message
...
Great advice. I renamed the tables and I think You are right. It
will
avoid
confusion.
So far I have this:
( http://img263.imageshack.us/img263/1...ellsample2.png )
Image for easier view and review.

What my goal is:
To create a form for a user which has Defined fields for WorkerType,
Underneeth Worker Name, and across CrewName all there because there
are
only
handfull of guys for each WorkerType.

The User will input only a number of CrewName he/she had for that
day..
So
if WorkenName had 1 Formen, 2 Workers and 4 Laborers under him/her.
She
would
only enter 1 , 2 , 4 under her row for each CrewName. Then have
fields
for
totaling each thing automatically. Is this all passible with a form
or
do
I
have to do the totals as a querie and then create a summary report?

Am I making sense? The first excell image I think explains it very
nice
what
I mean.

Thanks Guys for helping me with this.

"Steve" wrote:

Hello Damian,

Your tables are still incorrect. To start, how about for clarity
naming
the
people Workers. The naming a group of workers Crew.

TblWorkerType
WorkerTypeID
WorkerType

TblWorker
WorkerID
WorkerFName
WorkerLName
WorkerTypeID

TblCrew
CrewID
CrewName for identifying different crews

TblCrewWorker
CrewWorkerID
CrewID
WorkerID

You can count the types of workers in a crew in a totals query that
includes
all the above tables on the fly.


Steve




"Damian" wrote in message
...
Made a mistake. Is there an Edit button here? hmm

Correction on the Tables:
So Far I have 3 Tables:

Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews Type
Table
so
you can choose from drop down menu.

Crews Data
t_CrewDataID autoNumber PK
t_CrewDataType will be Foreman, Workman, Laborer

Crews Type
t_CrewDetailID autoNumber
t_CrewDetailType will be Carpenter, Surveyor, Laborman

Sorry


"Damian" wrote:

Great Help, thanks to all for info and great links. I'm starting
to
get
the
Big Picture now.
The only thing I am confused is how will I buld a Form for the
guys
to
fill
out.
Maybe I should explain what I want to accomplish here.

So Far I have 2 Tables:
Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Workman - Foreman or Laborer Linked from Crews Data
Table

Crews Data
t_CrewsDataID autoNumber PK
t_CrewsDataType will be Foreman, Workman, Laborer

(Now the data Value that you mentioned 1 , 3 , 2 is the amount
of
Foreman/Workman/Laborer each Crew had. This field is to be
inserted
by
the
user. so should I still have a DataValue field in my Crews Data
table
when it
will be different for every t_CrewID and every T_CrewsID will
have
all
t_CrewsDataTypes?)
I have an excell for this but I want to create a databaseto do
this. I
took
a screenshot of the excell so you can understand it and help me
better.
(Hope
is ok to post links here like these, if not I am sorry)
(http://img21.imageshack.us/img21/6924/excellsample.png)

Thanks Again




"John W. Vinson" wrote:

On Thu, 23 Jul 2009 13:36:01 -0700, Damian

wrote:

I am Trying to create Daily Reports for my company.
I created tables for Carpenters, Laborers, Surveyors,
Ironworkers
etc.
Each of these has fields *_Name, #ofForeman, #ofWorkers,
#ofLaborers.
ex.
"Carpenters Table
CarpentersName Foreman Worekman Laborer
Joe 2 1
5
Bill 1 5
2
"
"Laborers Table
LaborersName Foreman Worekman Laborer
Frank 1 1 0
"
And so on (you get the picture)

Now are those tables Normalized? I know I am repeating
Foreman,Workman
&
Laborer in each one of them but each of these tables has
different
Names and
different quantaties of people.

I'd change your design completely. Putting data (the type of
worker)
in
a
tablename or a fieldname is simply WRONG DESIGN.

Workers
WorkerID Primary Key, perhaps an autonumber
WorkerName (I'd actually use LastName and FirstName as
separate
fields
WorkerType e.g. Carpenter, Laborer, Surveyor, ...

WorkerData
WorkerID link to Workers
DataType e.g. "Foreman", "Laborer"
DataValue your 2, 1, 5 etc., whatever they mean


I created a form for Carpenters - A tabular form so I see All
names
for each
Carpenter in seperate box and next to them their

Thank You Gina,
To answare your question about Data:
These tables are just part of the daily report. Once I get that done I have
already created tables for Equipment and Subcontractors.

Then the Final report will have every information that is required including
the date.
So I am thinking, and correct me if I am wrong, the date can only be in the
final report that will be printed, correct? Instead of having Date in a table
and entering it for each Crew member. I only need One date.

What do you think?
"Gina Whipp" wrote:

Damien,

1. You can change the tblJob to what you posted IF you only care about
numerical values.
2. Yes, you can enter data in tblCrewType
3. Yes, you chould be able to make a form similar to your Excel
spreadsheet.
4. As for getting rid of the Date field, you indicated in your original
posting you wanted Daily reports. How are you going to do this without
date? I am also thinking you will need to add jCompleted (Yes?No) field to
your tblJobs.
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
To answere your questions:
1. The values will be entered by a user. Depending on a day how many
Forman
he had under him, how many workers and laborers he was responsible for.
2. Worker and Crew are the same thing. (not to be confused with
Foreman/Workers/Laborers column. Its different Workers).
Steve just sugested to replace Crew with Worker to avoid confusion.

So the tables are very simple. There is no Date required.

tblCrew
cCrewID (PK- Auto #)
cFName
cLName
cCrewTypeID (is he a carpenter, laborer, lather or Ironworker. Linked to
table below. Probably Drop Down box in a form)

tblCrewType
ctID (PK - Auto#)
ctName (carpenter, laborer, lather or Ironworker. Can I enter them now
since
they are going to be Default?)

tblJobs
jJobID (PK - Auto #)
jJobDescription (Foreman - Workman - Laborer) (Thats all, only 3)
((((
If I only care about the Numerical Values for how many
Foreman-Workman-Laborer) each of the Crew had. Can I do this?
tblJobs
jJobID (PK - Auto #)
jNumberOfForemans (1,2,3,4 or whatever it will be.)
jNumberOfWorkman ( same as above)
jNumberOfLaborers (same as above)
)))

tbJobDetail
jdJobDetailID (PK - Auto #)
jdJobID
jdCrewID

With these tables can I make a Form that will resemble the excel sheet?

Thank You

"Gina Whipp" wrote:

Damien,

I have a couple of questions, at the bottom, BUT below is what I think
you
need so far...

tblCrew
cCrewID (PK-Autonumber)
cFirstName
cLastName
cCrewTypeID
etc...

tblCrewTypes
ctCrewTypeID
ctName
etc...

tblJobs
jJobID
jDate
jJobDescription
etc...
other job fields you might need

tblJobDetail
jdJobDetailID
jdJobID
jdCrewID

1. Where are you getting the numbers (values) from? Are you getting
that
from who is assigned to the Job?
2. The explanation you provided below confuses me as to the difference
between Worker and Crew, please explin?
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
But you see what I am trying to create, right? Under colums Crews on
that
excell are names of Workers, they are in TblWorkers. Column D which is
Carpenters, Laborers etc are the WorkerType, they are in TblWorkerType
which
will be linked to TblWorkers. Next we have columns E,F,G which is
Foreman-Workman-Laborers, They are under TblCrew.

Now where and how can I put the Values that are under
Foreman-Workman-Laborer for each worker?

Also should I do the totals is a querie and likn it to a form or do a
textbox on a form and write the equation there?

"Steve" wrote:

Bob Fox is not in your Excel example to see what you mean.

Steve


"Damian" wrote in message
...
I don't think I need TblForeman since Foreman field will not have
name,
it
only has a number. Like, Bob Fox(WorkerID) will have 2 Foreman(Crew
ID).
Thats what my question is, how do I create my tables to represent
this.
my TblCrew has 2 fields
CrewID
CrewName
This will only allor you to input the Crew name like Foreman or
worken
or
laborer. (these are the only 3) so should there be another CrewCount
in
this
Tbl? or should the Count be somewhere else?
Look at this excell (
http://img21.imageshack.us/img21/6924/excellsample.png )
This is what I am trying to create.

But I am little confused on how to link them in a form and create
Good,
Normalized Tables so there is no data repetition as I had in the
beginning.

"Steve" wrote:

You added more to the description of your database and now It seems
you
need
to modify your tables again! Consider:

TblForeman
ForemanID
ForemanFName
ForemanLName
other foreman fields you might need

TblDailyJob
DailyJobID
DailyJobDate
DailyJobDescription
ForemanID
other job fields you might need

TblDailyJobWorker
DailyJobWorkerID
DailyJobID
WorkerID

Keep previous TblWorkerType and TblWorker. Delete TblCrew and
TblCrewWorker.
You can get the names in a "crew" by getting all the workers on a
specific
daily job.

Steve


"Damian" wrote in message
...
Great advice. I renamed the tables and I think You are right. It
will
avoid
confusion.
So far I have this:
( http://img263.imageshack.us/img263/1...ellsample2.png )
Image for easier view and review.

What my goal is:
To create a form for a user which has Defined fields for
WorkerType,
Underneeth Worker Name, and across CrewName all there because
there
are
only
handfull of guys for each WorkerType.

The User will input only a number of CrewName he/she had for that
day..
So
if WorkenName had 1 Formen, 2 Workers and 4 Laborers under
him/her.
She
would
only enter 1 , 2 , 4 under her row for each CrewName. Then have
fields
for
totaling each thing automatically. Is this all passible with a
form
or
do
I
have to do the totals as a querie and then create a summary
report?

Am I making sense? The first excell image I think explains it
very
nice
what
I mean.

Thanks Guys for helping me with this.

"Steve" wrote:

Hello Damian,

Your tables are still incorrect. To start, how about for clarity
naming
the
people Workers. The naming a group of workers Crew.

TblWorkerType
WorkerTypeID
WorkerType

TblWorker
WorkerID
WorkerFName
WorkerLName
WorkerTypeID

TblCrew
CrewID
CrewName for identifying different crews

TblCrewWorker
CrewWorkerID
CrewID
WorkerID

You can count the types of workers in a crew in a totals query
that
includes
all the above tables on the fly.


Steve




"Damian" wrote in message
...
Made a mistake. Is there an Edit button here? hmm

Correction on the Tables:
So Far I have 3 Tables:

Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews
Type
Table
so
you can choose from drop down menu.

Crews Data
t_CrewDataID autoNumber PK

Damian,

Have you got the tables set up with relationships? Waiting for the
screenshot...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
No he is not a foreman. The names that are under Crews are like the MAIN
GUYS
and they have Foremans/workers/ and Laborers under them. We do not care
what
the names of them are, JUST how many are under him.

SO Jack Prates has 2 formens and 4 workers under him.

"Steve" wrote:

Your Excel worksheet is confusing! In Laborers, is Jack Pratas a foreman?
If
not, why does he have two foreman? Crews are typically defined as a group
of
workers under one foreman.

Steve


"Damian" wrote in message
...
But you see what I am trying to create, right? Under colums Crews on
that
excell are names of Workers, they are in TblWorkers. Column D which is
Carpenters, Laborers etc are the WorkerType, they are in TblWorkerType
which
will be linked to TblWorkers. Next we have columns E,F,G which is
Foreman-Workman-Laborers, They are under TblCrew.

Now where and how can I put the Values that are under
Foreman-Workman-Laborer for each worker?

Also should I do the totals is a querie and likn it to a form or do a
textbox on a form and write the equation there?

"Steve" wrote:

Bob Fox is not in your Excel example to see what you mean.

Steve


"Damian" wrote in message
...
I don't think I need TblForeman since Foreman field will not have
name,
it
only has a number. Like, Bob Fox(WorkerID) will have 2 Foreman(Crew
ID).
Thats what my question is, how do I create my tables to represent
this.
my TblCrew has 2 fields
CrewID
CrewName
This will only allor you to input the Crew name like Foreman or
worken
or
laborer. (these are the only 3) so should there be another CrewCount
in
this
Tbl? or should the Count be somewhere else?
Look at this excell (
http://img21.imageshack.us/img21/6924/excellsample.png )
This is what I am trying to create.

But I am little confused on how to link them in a form and create
Good,
Normalized Tables so there is no data repetition as I had in the
beginning.

"Steve" wrote:

You added more to the description of your database and now It seems
you
need
to modify your tables again! Consider:

TblForeman
ForemanID
ForemanFName
ForemanLName
other foreman fields you might need

TblDailyJob
DailyJobID
DailyJobDate
DailyJobDescription
ForemanID
other job fields you might need

TblDailyJobWorker
DailyJobWorkerID
DailyJobID
WorkerID

Keep previous TblWorkerType and TblWorker. Delete TblCrew and
TblCrewWorker.
You can get the names in a "crew" by getting all the workers on a
specific
daily job.

Steve


"Damian" wrote in message
...
Great advice. I renamed the tables and I think You are right. It
will
avoid
confusion.
So far I have this:
( http://img263.imageshack.us/img263/1...ellsample2.png )
Image for easier view and review.

What my goal is:
To create a form for a user which has Defined fields for
WorkerType,
Underneeth Worker Name, and across CrewName all there because
there
are
only
handfull of guys for each WorkerType.

The User will input only a number of CrewName he/she had for that
day..
So
if WorkenName had 1 Formen, 2 Workers and 4 Laborers under
him/her.
She
would
only enter 1 , 2 , 4 under her row for each CrewName. Then have
fields
for
totaling each thing automatically. Is this all passible with a
form
or
do
I
have to do the totals as a querie and then create a summary
report?

Am I making sense? The first excell image I think explains it
very
nice
what
I mean.

Thanks Guys for helping me with this.

"Steve" wrote:

Hello Damian,

Your tables are still incorrect. To start, how about for clarity
naming
the
people Workers. The naming a group of workers Crew.

TblWorkerType
WorkerTypeID
WorkerType

TblWorker
WorkerID
WorkerFName
WorkerLName
WorkerTypeID

TblCrew
CrewID
CrewName for identifying different crews

TblCrewWorker
CrewWorkerID
CrewID
WorkerID

You can count the types of workers in a crew in a totals query
that
includes
all the above tables on the fly.


Steve




"Damian" wrote in message
...
Made a mistake. Is there an Edit button here? hmm

Correction on the Tables:
So Far I have 3 Tables:

Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews
Type
Table
so
you can choose from drop down menu.

Crews Data
t_CrewDataID autoNumber PK
t_CrewDataType will be Foreman, Workman, Laborer

Crews Type
t_CrewDetailID autoNumber
t_CrewDetailType will be Carpenter, Surveyor, Laborman

Sorry


"Damian" wrote:

Great Help, thanks to all for info and great links. I'm
starting
to
get
the
Big Picture now.
The only thing I am confused is how will I buld a Form for
the
guys
to
fill
out.
Maybe I should explain what I want to accomplish here.

So Far I have 2 Tables:
Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Workman - Foreman or Laborer Linked from Crews
Data
Table

Crews Data
t_CrewsDataID autoNumber PK
t_CrewsDataType will be Foreman, Workman, Laborer

(Now the data Value that you mentioned 1 , 3 , 2 is the
amount
of
Foreman/Workman/Laborer each Crew had. This field is to be
inserted
by
the
user. so should I still have a DataValue field in my Crews
Data
table
when it
will be different for every t_CrewID and every T_CrewsID will
have
all
t_CrewsDataTypes?)
I have an excell for this but I want to create a databaseto
do
this. I
took
a screenshot of the excell so you can understand it and help
me
better.
(Hope
is ok to post links here like these, if not I am sorry)
(http://img21.imageshack.us/img21/6924/excellsample.png)

Thanks Again




"John W. Vinson" wrote:

On Thu, 23 Jul 2009 13:36:01 -0700, Damian

wrote:

I am Trying to create Daily Reports for my company.
I created tables for Carpenters, Laborers, Surveyors,
Ironworkers
etc.
Each of these has fields *_Name, #ofForeman, #ofWorkers,
#ofLaborers.
ex.
"Carpenters Table
CarpentersName Foreman Worekman Laborer
Joe 2 1
5
Bill 1 5
2
"
"Laborers Table
LaborersName Foreman Worekman Laborer
Frank 1 1
0
"
And so on (you get the picture)

Now are those tables Normalized? I know I am repeating
Foreman,Workman
&
Laborer in each one of them but each of these tables has
different
Names and
different quantaties of people.

I'd change your design completely. Putting data (the type
of
worker)
in
a
tablename or a fieldname is simply WRONG DESIGN.

Workers
WorkerID Primary Key, perhaps an autonumber
WorkerName (I'd actually use LastName and FirstName as
separate
fields
WorkerType e.g. Carpenter, Laborer, Surveyor, ...

WorkerData
WorkerID link to Workers
DataType e.g. "Foreman", "Laborer"
DataValue your 2, 1, 5 etc., whatever they mean


I created a form for Carpenters - A tabular form so I see
All
names
for each
Carpenter in seperate box and next to them their

Damian,

I feel deprived... you made talbes without me (only kidding). Make sure
tblEquipment and tblSubsctractors has a JobID (FK) field. How are you
compiling the Final report that it will include the date? OR are you going
to pull the date from some outside source? You will not be entering a date
for each Crew member but for each Job, so the date gets printed anytime you
print that job.

Perhaps we are both confused.... I THINK you are talking about the Date the
Job started?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Thank You Gina,
To answare your question about Data:
These tables are just part of the daily report. Once I get that done I
have
already created tables for Equipment and Subcontractors.

Then the Final report will have every information that is required
including
the date.
So I am thinking, and correct me if I am wrong, the date can only be in
the
final report that will be printed, correct? Instead of having Date in a
table
and entering it for each Crew member. I only need One date.

What do you think?
"Gina Whipp" wrote:

Damien,

1. You can change the tblJob to what you posted IF you only care about
numerical values.
2. Yes, you can enter data in tblCrewType
3. Yes, you chould be able to make a form similar to your Excel
spreadsheet.
4. As for getting rid of the Date field, you indicated in your original
posting you wanted Daily reports. How are you going to do this without
date? I am also thinking you will need to add jCompleted (Yes?No) field
to
your tblJobs.
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
To answere your questions:
1. The values will be entered by a user. Depending on a day how many
Forman
he had under him, how many workers and laborers he was responsible for.
2. Worker and Crew are the same thing. (not to be confused with
Foreman/Workers/Laborers column. Its different Workers).
Steve just sugested to replace Crew with Worker to avoid confusion.

So the tables are very simple. There is no Date required.

tblCrew
cCrewID (PK- Auto #)
cFName
cLName
cCrewTypeID (is he a carpenter, laborer, lather or Ironworker. Linked
to
table below. Probably Drop Down box in a form)

tblCrewType
ctID (PK - Auto#)
ctName (carpenter, laborer, lather or Ironworker. Can I enter them now
since
they are going to be Default?)

tblJobs
jJobID (PK - Auto #)
jJobDescription (Foreman - Workman - Laborer) (Thats all, only 3)
((((
If I only care about the Numerical Values for how many
Foreman-Workman-Laborer) each of the Crew had. Can I do this?
tblJobs
jJobID (PK - Auto #)
jNumberOfForemans (1,2,3,4 or whatever it will be.)
jNumberOfWorkman ( same as above)
jNumberOfLaborers (same as above)
)))

tbJobDetail
jdJobDetailID (PK - Auto #)
jdJobID
jdCrewID

With these tables can I make a Form that will resemble the excel sheet?

Thank You

"Gina Whipp" wrote:

Damien,

I have a couple of questions, at the bottom, BUT below is what I think
you
need so far...

tblCrew
cCrewID (PK-Autonumber)
cFirstName
cLastName
cCrewTypeID
etc...

tblCrewTypes
ctCrewTypeID
ctName
etc...

tblJobs
jJobID
jDate
jJobDescription
etc...
other job fields you might need

tblJobDetail
jdJobDetailID
jdJobID
jdCrewID

1. Where are you getting the numbers (values) from? Are you getting
that
from who is assigned to the Job?
2. The explanation you provided below confuses me as to the
difference
between Worker and Crew, please explin?
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
But you see what I am trying to create, right? Under colums Crews on
that
excell are names of Workers, they are in TblWorkers. Column D which
is
Carpenters, Laborers etc are the WorkerType, they are in
TblWorkerType
which
will be linked to TblWorkers. Next we have columns E,F,G which is
Foreman-Workman-Laborers, They are under TblCrew.

Now where and how can I put the Values that are under
Foreman-Workman-Laborer for each worker?

Also should I do the totals is a querie and likn it to a form or do
a
textbox on a form and write the equation there?

"Steve" wrote:

Bob Fox is not in your Excel example to see what you mean.

Steve


"Damian" wrote in message
...
I don't think I need TblForeman since Foreman field will not have
name,
it
only has a number. Like, Bob Fox(WorkerID) will have 2
Foreman(Crew
ID).
Thats what my question is, how do I create my tables to represent
this.
my TblCrew has 2 fields
CrewID
CrewName
This will only allor you to input the Crew name like Foreman or
worken
or
laborer. (these are the only 3) so should there be another
CrewCount
in
this
Tbl? or should the Count be somewhere else?
Look at this excell (
http://img21.imageshack.us/img21/6924/excellsample.png )
This is what I am trying to create.

But I am little confused on how to link them in a form and create
Good,
Normalized Tables so there is no data repetition as I had in the
beginning.

"Steve" wrote:

You added more to the description of your database and now It
seems
you
need
to modify your tables again! Consider:

TblForeman
ForemanID
ForemanFName
ForemanLName
other foreman fields you might need

TblDailyJob
DailyJobID
DailyJobDate
DailyJobDescription
ForemanID
other job fields you might need

TblDailyJobWorker
DailyJobWorkerID
DailyJobID
WorkerID

Keep previous TblWorkerType and TblWorker. Delete TblCrew and
TblCrewWorker.
You can get the names in a "crew" by getting all the workers on
a
specific
daily job.

Steve


"Damian" wrote in message
...
Great advice. I renamed the tables and I think You are right.
It
will
avoid
confusion.
So far I have this:
( http://img263.imageshack.us/img263/1...ellsample2.png )
Image for easier view and review.

What my goal is:
To create a form for a user which has Defined fields for
WorkerType,
Underneeth Worker Name, and across CrewName all there because
there
are
only
handfull of guys for each WorkerType.

The User will input only a number of CrewName he/she had for
that
day..
So
if WorkenName had 1 Formen, 2 Workers and 4 Laborers under
him/her.
She
would
only enter 1 , 2 , 4 under her row for each CrewName. Then
have
fields
for
totaling each thing automatically. Is this all passible with a
form
or
do
I
have to do the totals as a querie and then create a summary
report?

Am I making sense? The first excell image I think explains it
very
nice
what
I mean.

Thanks Guys for helping me with this.

"Steve" wrote:

Hello Damian,

Your tables are still incorrect. To start, how about for
clarity
naming
the
people Workers. The naming a group of workers Crew.

TblWorkerType
WorkerTypeID
WorkerType

TblWorker
WorkerID
WorkerFName
WorkerLName
WorkerTypeID

TblCrew
CrewID
CrewName for identifying different crews

TblCrewWorker
CrewWorkerID
CrewID
WorkerID

You can count the types of workers in a crew in a totals
query
that
includes
all the above tables on the fly.


Steve




"Damian" wrote in message
...
Made a mistake. Is there an Edit button here? hmm

Correction on the Tables:
So Far I have 3 Tables:

Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews
Type
Table
so
you can choose from drop down menu.

Crews Data
t_CrewDataID autoNumber PK

Here is the screenshot for Relationship.

http://img39.imageshack.us/img39/868...tion****ss.png



"Gina Whipp" wrote:

Damian,

Have you got the tables set up with relationships? Waiting for the
screenshot...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
No he is not a foreman. The names that are under Crews are like the MAIN
GUYS
and they have Foremans/workers/ and Laborers under them. We do not care
what
the names of them are, JUST how many are under him.

SO Jack Prates has 2 formens and 4 workers under him.

"Steve" wrote:

Your Excel worksheet is confusing! In Laborers, is Jack Pratas a foreman?
If
not, why does he have two foreman? Crews are typically defined as a group
of
workers under one foreman.

Steve


"Damian" wrote in message
...
But you see what I am trying to create, right? Under colums Crews on
that
excell are names of Workers, they are in TblWorkers. Column D which is
Carpenters, Laborers etc are the WorkerType, they are in TblWorkerType
which
will be linked to TblWorkers. Next we have columns E,F,G which is
Foreman-Workman-Laborers, They are under TblCrew.

Now where and how can I put the Values that are under
Foreman-Workman-Laborer for each worker?

Also should I do the totals is a querie and likn it to a form or do a
textbox on a form and write the equation there?

"Steve" wrote:

Bob Fox is not in your Excel example to see what you mean.

Steve


"Damian" wrote in message
...
I don't think I need TblForeman since Foreman field will not have
name,
it
only has a number. Like, Bob Fox(WorkerID) will have 2 Foreman(Crew
ID).
Thats what my question is, how do I create my tables to represent
this.
my TblCrew has 2 fields
CrewID
CrewName
This will only allor you to input the Crew name like Foreman or
worken
or
laborer. (these are the only 3) so should there be another CrewCount
in
this
Tbl? or should the Count be somewhere else?
Look at this excell (
http://img21.imageshack.us/img21/6924/excellsample.png )
This is what I am trying to create.

But I am little confused on how to link them in a form and create
Good,
Normalized Tables so there is no data repetition as I had in the
beginning.

"Steve" wrote:

You added more to the description of your database and now It seems
you
need
to modify your tables again! Consider:

TblForeman
ForemanID
ForemanFName
ForemanLName
other foreman fields you might need

TblDailyJob
DailyJobID
DailyJobDate
DailyJobDescription
ForemanID
other job fields you might need

TblDailyJobWorker
DailyJobWorkerID
DailyJobID
WorkerID

Keep previous TblWorkerType and TblWorker. Delete TblCrew and
TblCrewWorker.
You can get the names in a "crew" by getting all the workers on a
specific
daily job.

Steve


"Damian" wrote in message
...
Great advice. I renamed the tables and I think You are right. It
will
avoid
confusion.
So far I have this:
( http://img263.imageshack.us/img263/1...ellsample2.png )
Image for easier view and review.

What my goal is:
To create a form for a user which has Defined fields for
WorkerType,
Underneeth Worker Name, and across CrewName all there because
there
are
only
handfull of guys for each WorkerType.

The User will input only a number of CrewName he/she had for that
day..
So
if WorkenName had 1 Formen, 2 Workers and 4 Laborers under
him/her.
She
would
only enter 1 , 2 , 4 under her row for each CrewName. Then have
fields
for
totaling each thing automatically. Is this all passible with a
form
or
do
I
have to do the totals as a querie and then create a summary
report?

Am I making sense? The first excell image I think explains it
very
nice
what
I mean.

Thanks Guys for helping me with this.

"Steve" wrote:

Hello Damian,

Your tables are still incorrect. To start, how about for clarity
naming
the
people Workers. The naming a group of workers Crew.

TblWorkerType
WorkerTypeID
WorkerType

TblWorker
WorkerID
WorkerFName
WorkerLName
WorkerTypeID

TblCrew
CrewID
CrewName for identifying different crews

TblCrewWorker
CrewWorkerID
CrewID
WorkerID

You can count the types of workers in a crew in a totals query
that
includes
all the above tables on the fly.


Steve




"Damian" wrote in message
...
Made a mistake. Is there an Edit button here? hmm

Correction on the Tables:
So Far I have 3 Tables:

Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews
Type
Table
so
you can choose from drop down menu.

Crews Data
t_CrewDataID autoNumber PK
t_CrewDataType will be Foreman, Workman, Laborer

Crews Type
t_CrewDetailID autoNumber
t_CrewDetailType will be Carpenter, Surveyor, Laborman

Sorry


"Damian" wrote:

Great Help, thanks to all for info and great links. I'm
starting
to
get
the
Big Picture now.
The only thing I am confused is how will I buld a Form for
the
guys
to
fill
out.
Maybe I should explain what I want to accomplish here.

So Far I have 2 Tables:
Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Workman - Foreman or Laborer Linked from Crews
Data
Table

Crews Data
t_CrewsDataID autoNumber PK
t_CrewsDataType will be Foreman, Workman, Laborer

(Now the data Value that you mentioned 1 , 3 , 2 is the
amount
of
Foreman/Workman/Laborer each Crew had. This field is to be
inserted
by
the
user. so should I still have a DataValue field in my Crews
Data
table
when it
will be different for every t_CrewID and every T_CrewsID will
have
all
t_CrewsDataTypes?)
I have an excell for this but I want to create a databaseto
do
this. I
took
a screenshot of the excell so you can understand it and help
me
better.
(Hope
is ok to post links here like these, if not I am sorry)
(http://img21.imageshack.us/img21/6924/excellsample.png)

Thanks Again




"John W. Vinson" wrote:

On Thu, 23 Jul 2009 13:36:01 -0700, Damian

wrote:

I am Trying to create Daily Reports for my company.
I created tables for Carpenters, Laborers, Surveyors,
Ironworkers

I am so confused how I will put the whole summary of Daily report together
its crazy. I think it should be made as a report, but I need all the data
that needs to be entered by a user in forms. The Date field is only a date
for the day the daily report was created. Everyday it will be the same crew,
the only changes will be the number of Foreman/Worker/Laborer he/she had, and
the equipment used of course, but that will come later.

So the date I fugured, ill just put as a header on a report as ( NOW() )
what do you think?

Below I posted my relationship screen shot. Its a very simple daily report
but its so complicated to explain over the internet.

Let me ask you this, because I am not sure how to handel this is Access.
There will be like 8 users using this daily report I am desperately trying
to make.
Now I was thinking, first let me create a Database for each of them so they
can enter their data and I will collect all 8 and combine them. Now here
comes the crazy part...can they all enter data on their own computers and
then that information will be transfer to the MASTER SUMMARY REPORT that adds
up all the info so I wont have to spend time on compiling each of these 8
into a single one.
We have a server so linking wont be a problem. Its just probably lot of work
and code right?

or is there a simple way of ding it.

Also I dont understand how I can get the totals for each crew mamber
(Foreman+Workers+Laborers) and the SUM of all totals for all types of Crew
members (ex carpenters.)

wow that is a lot of information to take at once. I really appreciate your
help with this.
I thought it would be a simple thing. The excel sheet looks simple, but
making it a database oh wow. not that simple.
so just bare with me




"Gina Whipp" wrote:

Damian,

I feel deprived... you made talbes without me (only kidding). Make sure
tblEquipment and tblSubsctractors has a JobID (FK) field. How are you
compiling the Final report that it will include the date? OR are you going
to pull the date from some outside source? You will not be entering a date
for each Crew member but for each Job, so the date gets printed anytime you
print that job.

Perhaps we are both confused.... I THINK you are talking about the Date the
Job started?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Thank You Gina,
To answare your question about Data:
These tables are just part of the daily report. Once I get that done I
have
already created tables for Equipment and Subcontractors.

Then the Final report will have every information that is required
including
the date.
So I am thinking, and correct me if I am wrong, the date can only be in
the
final report that will be printed, correct? Instead of having Date in a
table
and entering it for each Crew member. I only need One date.

What do you think?
"Gina Whipp" wrote:

Damien,

1. You can change the tblJob to what you posted IF you only care about
numerical values.
2. Yes, you can enter data in tblCrewType
3. Yes, you chould be able to make a form similar to your Excel
spreadsheet.
4. As for getting rid of the Date field, you indicated in your original
posting you wanted Daily reports. How are you going to do this without
date? I am also thinking you will need to add jCompleted (Yes?No) field
to
your tblJobs.
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
To answere your questions:
1. The values will be entered by a user. Depending on a day how many
Forman
he had under him, how many workers and laborers he was responsible for.
2. Worker and Crew are the same thing. (not to be confused with
Foreman/Workers/Laborers column. Its different Workers).
Steve just sugested to replace Crew with Worker to avoid confusion.

So the tables are very simple. There is no Date required.

tblCrew
cCrewID (PK- Auto #)
cFName
cLName
cCrewTypeID (is he a carpenter, laborer, lather or Ironworker. Linked
to
table below. Probably Drop Down box in a form)

tblCrewType
ctID (PK - Auto#)
ctName (carpenter, laborer, lather or Ironworker. Can I enter them now
since
they are going to be Default?)

tblJobs
jJobID (PK - Auto #)
jJobDescription (Foreman - Workman - Laborer) (Thats all, only 3)
((((
If I only care about the Numerical Values for how many
Foreman-Workman-Laborer) each of the Crew had. Can I do this?
tblJobs
jJobID (PK - Auto #)
jNumberOfForemans (1,2,3,4 or whatever it will be.)
jNumberOfWorkman ( same as above)
jNumberOfLaborers (same as above)
)))

tbJobDetail
jdJobDetailID (PK - Auto #)
jdJobID
jdCrewID

With these tables can I make a Form that will resemble the excel sheet?

Thank You

"Gina Whipp" wrote:

Damien,

I have a couple of questions, at the bottom, BUT below is what I think
you
need so far...

tblCrew
cCrewID (PK-Autonumber)
cFirstName
cLastName
cCrewTypeID
etc...

tblCrewTypes
ctCrewTypeID
ctName
etc...

tblJobs
jJobID
jDate
jJobDescription
etc...
other job fields you might need

tblJobDetail
jdJobDetailID
jdJobID
jdCrewID

1. Where are you getting the numbers (values) from? Are you getting
that
from who is assigned to the Job?
2. The explanation you provided below confuses me as to the
difference
between Worker and Crew, please explin?
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
But you see what I am trying to create, right? Under colums Crews on
that
excell are names of Workers, they are in TblWorkers. Column D which
is
Carpenters, Laborers etc are the WorkerType, they are in
TblWorkerType
which
will be linked to TblWorkers. Next we have columns E,F,G which is
Foreman-Workman-Laborers, They are under TblCrew.

Now where and how can I put the Values that are under
Foreman-Workman-Laborer for each worker?

Also should I do the totals is a querie and likn it to a form or do
a
textbox on a form and write the equation there?

"Steve" wrote:

Bob Fox is not in your Excel example to see what you mean.

Steve


"Damian" wrote in message
...
I don't think I need TblForeman since Foreman field will not have
name,
it
only has a number. Like, Bob Fox(WorkerID) will have 2
Foreman(Crew
ID).
Thats what my question is, how do I create my tables to represent
this.
my TblCrew has 2 fields
CrewID
CrewName
This will only allor you to input the Crew name like Foreman or
worken
or
laborer. (these are the only 3) so should there be another
CrewCount
in
this
Tbl? or should the Count be somewhere else?
Look at this excell (
http://img21.imageshack.us/img21/6924/excellsample.png )
This is what I am trying to create.

But I am little confused on how to link them in a form and create
Good,
Normalized Tables so there is no data repetition as I had in the
beginning.

"Steve" wrote:

You added more to the description of your database and now It
seems
you
need
to modify your tables again! Consider:

TblForeman
ForemanID
ForemanFName
ForemanLName
other foreman fields you might need

TblDailyJob
DailyJobID
DailyJobDate
DailyJobDescription
ForemanID
other job fields you might need

TblDailyJobWorker
DailyJobWorkerID
DailyJobID
WorkerID

Keep previous TblWorkerType and TblWorker. Delete TblCrew and
TblCrewWorker.
You can get the names in a "crew" by getting all the workers on
a
specific
daily job.

Steve


"Damian" wrote in message
...
Great advice. I renamed the tables and I think You are right.
It
will
avoid
confusion.
So far I have this:
( http://img263.imageshack.us/img263/1...ellsample2.png )
Image for easier view and review.

What my goal is:
To create a form for a user which has Defined fields for
WorkerType,
Underneeth Worker Name, and across CrewName all there because
there
are
only
handfull of guys for each WorkerType.

The User will input only a number of CrewName he/she had for
that
day..
So
if WorkenName had 1 Formen, 2 Workers and 4 Laborers under
him/her.
She
would
only enter 1 , 2 , 4 under her row for each CrewName. Then
have
fields
for
totaling each thing automatically. Is this all passible with a
form
or
do
I
have to do the totals as a querie and then create a summary
report?

Am I making sense? The first excell image I think explains it
very
nice
what
I mean.

Thanks Guys for helping me with this.

"Steve" wrote:

Hello Damian,

Damian,

Okay, you missed informing us of quite a few tables which means your data
model is based on more then your original post. Your Daily Report table
really should not be a table at all. (You also have used so many styles
creating your tables it is slightly confusing.)

Do these tables have any confidential information them?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Here is the screenshot for Relationship.

http://img39.imageshack.us/img39/868...tion****ss.png



"Gina Whipp" wrote:

Damian,

Have you got the tables set up with relationships? Waiting for the
screenshot...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
No he is not a foreman. The names that are under Crews are like the
MAIN
GUYS
and they have Foremans/workers/ and Laborers under them. We do not care
what
the names of them are, JUST how many are under him.

SO Jack Prates has 2 formens and 4 workers under him.

"Steve" wrote:

Your Excel worksheet is confusing! In Laborers, is Jack Pratas a
foreman?
If
not, why does he have two foreman? Crews are typically defined as a
group
of
workers under one foreman.

Steve


"Damian" wrote in message
...
But you see what I am trying to create, right? Under colums Crews on
that
excell are names of Workers, they are in TblWorkers. Column D which
is
Carpenters, Laborers etc are the WorkerType, they are in
TblWorkerType
which
will be linked to TblWorkers. Next we have columns E,F,G which is
Foreman-Workman-Laborers, They are under TblCrew.

Now where and how can I put the Values that are under
Foreman-Workman-Laborer for each worker?

Also should I do the totals is a querie and likn it to a form or do
a
textbox on a form and write the equation there?

"Steve" wrote:

Bob Fox is not in your Excel example to see what you mean.

Steve


"Damian" wrote in message
...
I don't think I need TblForeman since Foreman field will not have
name,
it
only has a number. Like, Bob Fox(WorkerID) will have 2
Foreman(Crew
ID).
Thats what my question is, how do I create my tables to represent
this.
my TblCrew has 2 fields
CrewID
CrewName
This will only allor you to input the Crew name like Foreman or
worken
or
laborer. (these are the only 3) so should there be another
CrewCount
in
this
Tbl? or should the Count be somewhere else?
Look at this excell (
http://img21.imageshack.us/img21/6924/excellsample.png )
This is what I am trying to create.

But I am little confused on how to link them in a form and create
Good,
Normalized Tables so there is no data repetition as I had in the
beginning.

"Steve" wrote:

You added more to the description of your database and now It
seems
you
need
to modify your tables again! Consider:

TblForeman
ForemanID
ForemanFName
ForemanLName
other foreman fields you might need

TblDailyJob
DailyJobID
DailyJobDate
DailyJobDescription
ForemanID
other job fields you might need

TblDailyJobWorker
DailyJobWorkerID
DailyJobID
WorkerID

Keep previous TblWorkerType and TblWorker. Delete TblCrew and
TblCrewWorker.
You can get the names in a "crew" by getting all the workers on
a
specific
daily job.

Steve


"Damian" wrote in message
...
Great advice. I renamed the tables and I think You are right.
It
will
avoid
confusion.
So far I have this:
( http://img263.imageshack.us/img263/1...ellsample2.png )
Image for easier view and review.

What my goal is:
To create a form for a user which has Defined fields for
WorkerType,
Underneeth Worker Name, and across CrewName all there because
there
are
only
handfull of guys for each WorkerType.

The User will input only a number of CrewName he/she had for
that
day..
So
if WorkenName had 1 Formen, 2 Workers and 4 Laborers under
him/her.
She
would
only enter 1 , 2 , 4 under her row for each CrewName. Then
have
fields
for
totaling each thing automatically. Is this all passible with a
form
or
do
I
have to do the totals as a querie and then create a summary
report?

Am I making sense? The first excell image I think explains it
very
nice
what
I mean.

Thanks Guys for helping me with this.

"Steve" wrote:

Hello Damian,

Your tables are still incorrect. To start, how about for
clarity
naming
the
people Workers. The naming a group of workers Crew.

TblWorkerType
WorkerTypeID
WorkerType

TblWorker
WorkerID
WorkerFName
WorkerLName
WorkerTypeID

TblCrew
CrewID
CrewName for identifying different crews

TblCrewWorker
CrewWorkerID
CrewID
WorkerID

You can count the types of workers in a crew in a totals
query
that
includes
all the above tables on the fly.


Steve




"Damian" wrote in message
...
Made a mistake. Is there an Edit button here? hmm

Correction on the Tables:
So Far I have 3 Tables:

Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews
Type
Table
so
you can choose from drop down menu.

Crews Data
t_CrewDataID autoNumber PK
t_CrewDataType will be Foreman, Workman, Laborer

Crews Type
t_CrewDetailID autoNumber
t_CrewDetailType will be Carpenter, Surveyor, Laborman

Sorry


"Damian" wrote:

Great Help, thanks to all for info and great links. I'm
starting
to
get
the
Big Picture now.
The only thing I am confused is how will I buld a Form for
the
guys
to
fill
out.
Maybe I should explain what I want to accomplish here.

So Far I have 2 Tables:
Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Workman - Foreman or Laborer Linked from Crews
Data
Table

Crews Data
t_CrewsDataID autoNumber PK
t_CrewsDataType will be Foreman, Workman, Laborer

(Now the data Value that you mentioned 1 , 3 , 2 is the
amount
of
Foreman/Workman/Laborer each Crew had. This field is to be
inserted
by
the
user. so should I still have a DataValue field in my Crews
Data
table
when it
will be different for every t_CrewID and every T_CrewsID
will
have
all
t_CrewsDataTypes?)
I have an excell for this but I want to create a
databaseto
do
this. I
took
a screenshot of the excell so you can understand it and
help
me
better.
(Hope
is ok to post links here like these, if not I am sorry)
(http://img21.imageshack.us/img21/6924/excellsample.png)

Thanks Again




"John W. Vinson" wrote:

On Thu, 23 Jul 2009 13:36:01 -0700, Damian

wrote:

I am Trying to create Daily Reports for my company.
I created tables for Carpenters, Laborers, Surveyors,
Ironworkers

Damien,

Everyone can make an Excel spreadsheet but an Access database, not everyone
on the someones can.

Number one, STOP thinking about the report at this stage of the game. STOP
thinking about Summing or anything else. As a matter of fact STOP thinking
about ANYTHING but the tables. (You can't hang drapes in a room that has no
walls or windows.) I need you also STOP trying to set up tables like you
see them in reports, it won't work. Tables just hold data and really don't
care how they look and neither should you.

I have looked at the image containing your screen shots and commented
further down in the other post so I will leave that alone.

Okay on the Date field leave it out (or put it in and just don't use, it may
come up later).

AFTER the database is complete it will be split so your 8 Users will be able
to enter their prospective data.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
I am so confused how I will put the whole summary of Daily report together
its crazy. I think it should be made as a report, but I need all the data
that needs to be entered by a user in forms. The Date field is only a date
for the day the daily report was created. Everyday it will be the same
crew,
the only changes will be the number of Foreman/Worker/Laborer he/she had,
and
the equipment used of course, but that will come later.

So the date I fugured, ill just put as a header on a report as ( NOW() )
what do you think?

Below I posted my relationship screen shot. Its a very simple daily report
but its so complicated to explain over the internet.

Let me ask you this, because I am not sure how to handel this is Access.
There will be like 8 users using this daily report I am desperately trying
to make.
Now I was thinking, first let me create a Database for each of them so
they
can enter their data and I will collect all 8 and combine them. Now here
comes the crazy part...can they all enter data on their own computers and
then that information will be transfer to the MASTER SUMMARY REPORT that
adds
up all the info so I wont have to spend time on compiling each of these 8
into a single one.
We have a server so linking wont be a problem. Its just probably lot of
work
and code right?

or is there a simple way of ding it.

Also I dont understand how I can get the totals for each crew mamber
(Foreman+Workers+Laborers) and the SUM of all totals for all types of Crew
members (ex carpenters.)

wow that is a lot of information to take at once. I really appreciate your
help with this.
I thought it would be a simple thing. The excel sheet looks simple, but
making it a database oh wow. not that simple.
so just bare with me




"Gina Whipp" wrote:

Damian,

I feel deprived... you made talbes without me (only kidding). Make sure
tblEquipment and tblSubsctractors has a JobID (FK) field. How are you
compiling the Final report that it will include the date? OR are you
going
to pull the date from some outside source? You will not be entering a
date
for each Crew member but for each Job, so the date gets printed anytime
you
print that job.

Perhaps we are both confused.... I THINK you are talking about the Date
the
Job started?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Thank You Gina,
To answare your question about Data:
These tables are just part of the daily report. Once I get that done I
have
already created tables for Equipment and Subcontractors.

Then the Final report will have every information that is required
including
the date.
So I am thinking, and correct me if I am wrong, the date can only be in
the
final report that will be printed, correct? Instead of having Date in a
table
and entering it for each Crew member. I only need One date.

What do you think?
"Gina Whipp" wrote:

Damien,

1. You can change the tblJob to what you posted IF you only care
about
numerical values.
2. Yes, you can enter data in tblCrewType
3. Yes, you chould be able to make a form similar to your Excel
spreadsheet.
4. As for getting rid of the Date field, you indicated in your
original
posting you wanted Daily reports. How are you going to do this
without
date? I am also thinking you will need to add jCompleted (Yes?No)
field
to
your tblJobs.
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
To answere your questions:
1. The values will be entered by a user. Depending on a day how many
Forman
he had under him, how many workers and laborers he was responsible
for.
2. Worker and Crew are the same thing. (not to be confused with
Foreman/Workers/Laborers column. Its different Workers).
Steve just sugested to replace Crew with Worker to avoid confusion.

So the tables are very simple. There is no Date required.

tblCrew
cCrewID (PK- Auto #)
cFName
cLName
cCrewTypeID (is he a carpenter, laborer, lather or Ironworker.
Linked
to
table below. Probably Drop Down box in a form)

tblCrewType
ctID (PK - Auto#)
ctName (carpenter, laborer, lather or Ironworker. Can I enter them
now
since
they are going to be Default?)

tblJobs
jJobID (PK - Auto #)
jJobDescription (Foreman - Workman - Laborer) (Thats all, only 3)
((((
If I only care about the Numerical Values for how many
Foreman-Workman-Laborer) each of the Crew had. Can I do this?
tblJobs
jJobID (PK - Auto #)
jNumberOfForemans (1,2,3,4 or whatever it will be.)
jNumberOfWorkman ( same as above)
jNumberOfLaborers (same as above)
)))

tbJobDetail
jdJobDetailID (PK - Auto #)
jdJobID
jdCrewID

With these tables can I make a Form that will resemble the excel
sheet?

Thank You

"Gina Whipp" wrote:

Damien,

I have a couple of questions, at the bottom, BUT below is what I
think
you
need so far...

tblCrew
cCrewID (PK-Autonumber)
cFirstName
cLastName
cCrewTypeID
etc...

tblCrewTypes
ctCrewTypeID
ctName
etc...

tblJobs
jJobID
jDate
jJobDescription
etc...
other job fields you might need

tblJobDetail
jdJobDetailID
jdJobID
jdCrewID

1. Where are you getting the numbers (values) from? Are you
getting
that
from who is assigned to the Job?
2. The explanation you provided below confuses me as to the
difference
between Worker and Crew, please explin?
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
But you see what I am trying to create, right? Under colums Crews
on
that
excell are names of Workers, they are in TblWorkers. Column D
which
is
Carpenters, Laborers etc are the WorkerType, they are in
TblWorkerType
which
will be linked to TblWorkers. Next we have columns E,F,G which is
Foreman-Workman-Laborers, They are under TblCrew.

Now where and how can I put the Values that are under
Foreman-Workman-Laborer for each worker?

Also should I do the totals is a querie and likn it to a form or
do
a
textbox on a form and write the equation there?

"Steve" wrote:

Bob Fox is not in your Excel example to see what you mean.

Steve


"Damian" wrote in message
...
I don't think I need TblForeman since Foreman field will not
have
name,
it
only has a number. Like, Bob Fox(WorkerID) will have 2
Foreman(Crew
ID).
Thats what my question is, how do I create my tables to
represent
this.
my TblCrew has 2 fields
CrewID
CrewName
This will only allor you to input the Crew name like Foreman
or
worken
or
laborer. (these are the only 3) so should there be another
CrewCount
in
this
Tbl? or should the Count be somewhere else?
Look at this excell (
http://img21.imageshack.us/img21/6924/excellsample.png )
This is what I am trying to create.

But I am little confused on how to link them in a form and
create
Good,
Normalized Tables so there is no data repetition as I had in
the
beginning.

"Steve" wrote:

You added more to the description of your database and now It
seems
you
need
to modify your tables again! Consider:

TblForeman
ForemanID
ForemanFName
ForemanLName
other foreman fields you might need

TblDailyJob
DailyJobID
DailyJobDate
DailyJobDescription
ForemanID
other job fields you might need

TblDailyJobWorker
DailyJobWorkerID
DailyJobID
WorkerID

Keep previous TblWorkerType and TblWorker. Delete TblCrew and
TblCrewWorker.
You can get the names in a "crew" by getting all the workers
on
a
specific
daily job.

Steve


"Damian" wrote in message
...
Great advice. I renamed the tables and I think You are
right.
It
will
avoid
confusion.
So far I have this:
(
http://img263.imageshack.us/img263/1...ellsample2.png )
Image for easier view and review.

What my goal is:
To create a form for a user which has Defined fields for
WorkerType,
Underneeth Worker Name, and across CrewName all there
because
there
are
only
handfull of guys for each WorkerType.

The User will input only a number of CrewName he/she had
for
that
day..
So
if WorkenName had 1 Formen, 2 Workers and 4 Laborers under
him/her.
She
would
only enter 1 , 2 , 4 under her row for each CrewName. Then
have
fields
for
totaling each thing automatically. Is this all passible
with a
form
or
do
I
have to do the totals as a querie and then create a summary
report?

Am I making sense? The first excell image I think explains
it
very
nice
what
I mean.

Thanks Guys for helping me with this.

"Steve" wrote:

Hello Damian,