Re: Update Query

From: Dale Brown (dalebrown_at_gaitkeeper.com)
Date: 02/27/05 

Date: Sat, 26 Feb 2005 21:40:33 -0600

Ken,

The select scoreid from classinfoscore will return just one record. I am
trying to update the scoreid field in a number of records in my classinfo
table. The classinfoscore has 1 record with one field scoreid in it. This is
a temporary table set based on what a user selects in a listbox on a form.
The classinfo table has classes from many different shows. The joining on
the activeshow table allows me to tell which show the user is working on.
The user will also enter a starting and ending classnumber on the form. This
is where the where clause comes into play. Let me know if you need more
information or if this is enough.

Dale
"Ken Snell [MVP]" <kthsneisllis9@ncoomcastt.renaetl> wrote in message
news:upSwexHHFHA.3484@TK2MSFTNGP12.phx.gbl...
> You'll need to tell us what you're trying to do, including what your table
> structures are and such.
>
> It's not clear from the SQL statement that you've posted. Is the
> (select scoreid from classinfoscore)
> clause going to return just one record? or multiple records?
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
> "Dale Brown" <dalebrown@gaitkeeper.com> wrote in message
> news:%23RewUuHHFHA.472@TK2MSFTNGP12.phx.gbl...
>>I have never done an update query in Access yet. Here is what I have tried
>>but it will not work. Can anyone help with the syntax?
>>
>> update classinfo
>> INNER JOIN activeshow ON ActiveShow.ShowID=ClassInfo.ShowID
>> WHERE classinfo.classnumber Between forms!ClassFill!begnbr And
>> forms!ClassFill!endnbr
>> set scoreid = (select scoreid from classinfoscore)
>>
>
>