UPDATE SQL Help

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

hi,
i have 2 tables: tbl-LAWYERMembership and Case Info. What
i would like to do is move a Lawyer's name from tbl-
LAWYERMembership (the field name is FULL), where a
checkbox is checked, to a field in Case Info
called "LAWYER". I have the following SQL statement, but
i keep getting errors.

UPDATE [Case Info] SET [Case Info].LAWYER = [tables] !
[tbl-LAWYERMembership] ! [FULL] WHERE ResponseCheckBox
= 'TRUE';

Can someone please correct me?

thanks in advance,
Rob
 
UPDATE [Case Info] SET LAWYER = tbl-LAWYERMembership.FULL WHERE
tbl-LAWYERMembership.ResponseCheckBox = 'TRUE'
from LAWYERMembership

If ResponseCheckBox is defined a bit, then put = 1 instead of TRUE
 
hi again,

i got an error saying that an operator was missing. here
is what i have:

UPDATE [Case Info] SET LAWYER = tbl-LAWYERMembership.FULL
WHERE
tbl-LAWYERMembership.ResponseCheckBox = 'TRUE'
from tbl-LAWYERMembership;

can you please correct it again?? thanks a lot!!!

-Rob
 
sorry there was a mystake in it hope this takes care of it

UPDATE [Case Info] SET LAWYER = tbl-LAWYERMembership.FULL
from tbl-LAWYERMembership
WHERE tbl-LAWYERMembership.ResponseCheckBox = 'TRUE'
 
UPDATE [Case Info] SET [Case Info].LAWYER = tbl-LAWYERMembership.FULL
from tbl-LAWYERMembership
WHERE tbl-LAWYERMembership.ResponseCheckBox = 'TRUE'

J Arty said:
sorry there was a mystake in it hope this takes care of it

UPDATE [Case Info] SET LAWYER = tbl-LAWYERMembership.FULL
from tbl-LAWYERMembership
WHERE tbl-LAWYERMembership.ResponseCheckBox = 'TRUE'

hi again,

i got an error saying that an operator was missing. here
is what i have:

UPDATE [Case Info] SET LAWYER = tbl-LAWYERMembership.FULL
WHERE
tbl-LAWYERMembership.ResponseCheckBox = 'TRUE'
from tbl-LAWYERMembership;

can you please correct it again?? thanks a lot!!!

-Rob
Click to expand...
Click to expand...
 
i still get an error message which says: "Syntax error
(missing operator) in query expression 'tbl-
LAWYERMembership.FULL from tbl-LAWYERMembership" i'm
sorry to bother you again, but could you look it over one
more time?

thanks,
Rob

-----Original Message-----
UPDATE [Case Info] SET [Case Info].LAWYER = tbl- LAWYERMembership.FULL
from tbl-LAWYERMembership
WHERE tbl-LAWYERMembership.ResponseCheckBox = 'TRUE'

J Arty said:
sorry there was a mystake in it hope this takes care of it

UPDATE [Case Info] SET LAWYER = tbl- LAWYERMembership.FULL
from tbl-LAWYERMembership
WHERE tbl-LAWYERMembership.ResponseCheckBox = 'TRUE'

hi again,

i got an error saying that an operator was missing. here
is what i have:

UPDATE [Case Info] SET LAWYER = tbl- LAWYERMembership.FULL
WHERE
tbl-LAWYERMembership.ResponseCheckBox = 'TRUE'
from tbl-LAWYERMembership;

can you please correct it again?? thanks a lot!!!

-Rob
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top