Text Fields

[paulS30berks]

I have imported a link table into access.

The Year field I wish to search on is Text.

I have entered a wildcard before the year i.e *2003 within the criteria, but still cannot read the number.

Can anyone suggest anything?

Thanks

Paul

 

[micks55]

Try *2003* or Like "*2003*" or Like "*" & 2003 & "*". Good luck.