Okie dokie then... I see you have only snipped out the parts that make you
seem sane...

As for the recording you are doing... if you mean interjecting by letting
the OP know that these are FREE newsgroups where they can get FREE help by
all means keep recording...

--
Gina Whipp

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

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

"Steve" help_available_at_very_reasonable_rates@contactme .com wrote in
message ...
I do track your responses

I am not *stalking* you

You're a hypocrtite who speaks out of both sides of your mouth.

Perhaps you should look up the word stalking in the dictionary.

Stalking is a criminal act and I am recording each time you interject
anything destructive to one of my posts.

Steve

"Gina Whipp" wrote in message
...
Steve,

I do track your responses, along with others, but yours because you keep
offering fee-based services in a FREE newsgroup and I feel the OP has a
right to get their question answered for FREE in this FREE forum. I do
not interject false statements and certainly not where it concerns you.
I am not *stalking* you or anyone else, perhaps you should look up the
word in the dictionary.

--
Gina Whipp

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

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

"Steve" help_available_at_very_reasonable_rates@contactme .com wrote in
message m...
It certainly is stalking when you track my responses to OPs and
interject false statements. Stalking is a criminal act!!!

Steve


"Gina Whipp" wrote in message
...
Not stalking... not sure where you get that from. Here I am here now
and I see you provided the tables I would thank you but you would
probably find a way to twist that around...

--
Gina Whipp

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

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

"Steve" help_available_at_very_reasonable_rates@contactme .com wrote
in message m...
You are too busy to answer the OP but not to busy to stalk me! Go
figure???

Steve


"Gina Whipp" wrote in message
...
I am a little busy right now BUT if no one gets back to you by the
time I get UNbusy I will review your tables.

--
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
...
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


Get your table design right first and then work on the forms.
--

John W. Vinson [MVP]