Criteria of two field values being equal

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

Guest

I need to create a query that returns records from a table where the first
six characters from one field equals the first six characters from another,
and then write an "x" as the value for a third field.

Any help in how the syntax should look for this task would be much
appreciated.

Thanks in advance for any advice.
 
How about something like this:

UPDATE
SET [Field3]='x'
WHERE Left([Field1],6)=Left([Field2],6)

Carl Rapson
 
Marvelous!! Worked like a charm. How easy you make these things look. I'm so
thankful for this resource. You guys are awesome!
--
BJM
ACE Assistant
Gary Allan High School


Carl Rapson said:
How about something like this:

UPDATE
SET [Field3]='x'
WHERE Left([Field1],6)=Left([Field2],6)

Carl Rapson
Click to expand...
 
Back
Top