matching two fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to tables and both has a field "tougou", one table has another field
"flag", I want to match the value of field "tougou" and for those doesn't
match then calculate the flag into 1.

I have also a question, both field should the same length?

any suggestion would highly appreciated

Thanks
Jhun
 
You need to link the two tables in an update query. Show both 'tougou'
fields and the 'flag' field. You then put an expression in the criteria for
the 'tougou' field in the table that doesn;t include the 'flag' field that
says: <>othertablename.tougou

You then set the update parameter of the 'flag' field to 1. Show the
results to check that the criteria is having an effect, then run the query.
Make sure you back up your data before experimenting with update and append
queries!!

Ian
 
Thanks for the reply, Is there a way to make it in a sql method because I
want to apply it programatically. could you give me a sample code because I'm
only a beginner in microsoft access.

Thanks a lot
 
Back
Top