Select records based on field value

[lawtonl]

Hi,

I have 2 tables tblMPN's and tblIncidents and they're linked by account number. In MPN's I have the field fldQuoteName and I need to only select records that match fldIncidentID in tblIncidents.

However, the data in fldQuoteName is inconsisistant. It contains a string which is a combination of account number/incident number or incident number/account number like so...

55448887/P45654
55486213/G48943
R15486/15656566
15365156/B15643

Is there a way I can select a record if fldQuotename is like *fldIncidentID* I've tried something so simple in Access and it retrieves no records at all.

tia

 

[gemma-the-husky]

try something like this - you need to concatenate the * character with the VALUE OF the field, not with the fieldname itself

like "*" & [fldIncidentID] & "*"

 

[lawtonl]

Genius, Thank you sir you are my hero of the hour!