Create a new field that will convert the numeric field into a string:

NewFieldName: Cstr(NumericFieldname)

You can now create a relationship between NewFieldName and your text field.

Posted on November 8th, 2008 | filed under Microsoft Access 2007 | Trackback |

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <font color="" face="" size=""> <span style="">