Thread: Update queries
View Single Post
  #4  
Old October 12th, 2004, 06:52 PM
Brendan Reynolds
external usenet poster
 
Posts: n/a
Default

If I understand this correctly, you've answered two of the four questions to
which I would need answers in order to be able to help you. It seems that
you want to update all records in one table. But I still have no answer to
the other two questions - what values you want to put into what fields? Your
update query will look something like this ...

UPDATE YourTableName SET YourFieldName(s) = YourValue(s)

.... but given the information provided so far, there is no way for me to
know what "YourFieldName(s)" or "YourValues(s)" should be.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.


"wheelz" wrote in message
...
On the table there is a list of 20 names. Each name get every holiday and
a
set number of holiday hours for it. I am trying to update the table so
that
when the update query runs, every name get all 12 holidays. On the table
I
want it to show the name, the holiday and their holiday hours for all 20
names, it should display all 12 holidays for all 20 names.

Matt

"Brendan Reynolds" wrote:

It's not what's on the form that matters, it's what's in the tables. When
you say 'update 12 holidays for 20 people', what does that mean in terms
of
which fields you want to set to what values in which records of which
tables?

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible
for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.


"wheelz" wrote in message
...
I am trying to set up an update query to update 12 holidays for 20
people.
But this is my first time doing an update query. The user picks a
holiday,
and based on that choice each person gets the holiday off and their
number
of
holidays given is displayed. The only fields on the form are the
employee's
name, holiday, holiday_hrs, holiday_date. Does anyone have any
suggestions
or hints to help me out.

Matt