Need Help With Qry

O

oxicottin

I have a completed form and I need to create a qry. The qry needs to ask for
a specific Employee name from 7 text boxes. Please help im lost...

Reguards,
Chad
 
J

Jason Lepack

I have a completed form and I need to create a qry. The qry needs to ask for
a specific Employee name from 7 text boxes. Please help im lost...

Reguards,
Chad
Click to expand...

Me too, I have no idea what you just asked. Is the name Joe? Bob?
You have to give information or you can't be helped.
 
O

oxicottin

I have 7 text boxes named operator 1 threw operator 7. I have production
lines 1 threw 7 and what I want to do is get all the information pertaining
to that operator. For example: Operator 1 who’s name is Bill has a number of
different things in that particular row that he accomplished. I want to pick
out those things for that operator with a
qry.http://i54.photobucket.com/albums/g94/oxicottin/Image2.jpg
 
J

Jerry Whittle

Step away from the keyboard! You are trying to "commit spreadsheet". Your
table has serious normalization problems and just will NOT work correctly in
a relational database.

OK. OK. I'm being overly harsh but not by much. What happens when someone
says that you need an 8th operator? You'll have to redesign not only your
table, but also any queries, reports, and forms based on that table. All the
Operators should be in one field down and not across as in a spreadsheet.

I highly suggest getting some relational database training or reading
"Database Design for Mere Mortals" by Hernandez before proceeding any further
on this database.

Here's a couple of on-line resources.

http://support.microsoft.com/kb/100139/en-us

http://support.microsoft.com/kb/234208/
 
Top