Table linking question

[hfc6301]

I have 2 tables and am trying to find a way to link them. In one table I have a field that is called comments that would have something like "Birdstrike hit windshield" and in the other table I have a field called exceptions that has "bird" in it. I know there is probably not a way to link them, but would appreciate it any help if you know of a way.

Thanks

 

[Andrzejek]

Wild guess here...
[pre]

TableA TableB
FieldA FieldB[blue]
bird Bird[/blue]strike hit windshield
[/pre][tt]
Select TableA.*, TableB.*
From TableA, TableB
WHERE UCase(TableA.FieldA) = Left(UCase(TableB.FieldB), Len(TableA.FieldA)[/tt]


Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[dhookom]

I don't think you can link/join on a "like" in Access but you could use something like this where the "bird" is tableB.FieldB:

Select TableA.*, TableB.*
From TableA, TableB
WHERE TableA.FieldA Like "*" & TableB.FieldB & "*"

Duane
Hook'D on Access
MS Access MVP