How SSN is stored in the table, with dashes or w/o? Does
SELECT tblcontributions
BROWSE FOR ssnumber = "222222222"
BROWSE FOR ssnumber = "222-22-2222"
displays any records?
>Trying a view for the first time with a parameter but have problems getting the data. Heres my SQL:
>SELECT Tblcontributions.*;
> FROM ;
> data1!tblcontributions;
> WHERE Tblcontributions.ssnumber = ( ?parssnumber );
> ORDER BY Tblcontributions.periodend
>
>When I run it and eneter a ss number as either 222222222 or 222-22-2222 it comes up empty in the browse.
>
>The ssnumber is a character type, size 11 with an input mask of 999-99-9999. Can't figure out what I am doing wrong.
>
--sb--