Like operator refering to fields

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

Guest

I have got a query that should match up similar records from two tables.
In a field's criteria section I have got the expression: [field1] like
[field2]. However this only displays exact matches. How can I get it to
display all similar matches.
 
Hi pezza88,

You just miss the wild card (*) to include all the similar matches.
Try this.

[field1] like [field2] & "*"

Hope this helps.
 
It is still doing the same thing: only picking up exact matches

JL said:
Hi pezza88,

You just miss the wild card (*) to include all the similar matches.
Try this.

[field1] like [field2] & "*"

Hope this helps.


pezza88 said:
I have got a query that should match up similar records from two tables.
In a field's criteria section I have got the expression: [field1] like
[field2]. However this only displays exact matches. How can I get it to
display all similar matches.
Click to expand...
Click to expand...
 
Hi pezza88,

Now, I am puzzled. Can you post your SQL and sample data (include spaces or
white spaces)?


pezza88 said:
It is still doing the same thing: only picking up exact matches

JL said:
Hi pezza88,

You just miss the wild card (*) to include all the similar matches.
Try this.

[field1] like [field2] & "*"

Hope this helps.


pezza88 said:
I have got a query that should match up similar records from two tables.
In a field's criteria section I have got the expression: [field1] like
[field2]. However this only displays exact matches. How can I get it to
display all similar matches.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top