Criteria of two field values being equal

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.
--
BJM
ACE Assistant
Gary Allan High School

How about something like this:

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

Carl Rapson

"B. Meincke" wrote in message
...
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.
--
BJM
ACE Assistant
Gary Allan High School

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" wrote:

How about something like this:

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

Carl Rapson

"B. Meincke" wrote in message
...
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.
--
BJM
ACE Assistant
Gary Allan High School