This is a bad choice for a PK as SSN is not unique. There are a small number of duplicates that have been issued.
>I am trying to set a primary key for a character field and a date field through an expression. I have thhe following:
>
>ssnumber+orderdate
>
>ssnumber is a character field and the orderdate is a date field. When I try and save it I get the following:
>
>Operator/operand type mismatch
>
>Newbie and need help.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer