I can help with this. Is the Social Security Number stored in the database formatted with the dashes or is it stored only as the digits? I'm assuming that you have them enter a SSN with the dashes and use it as a criteria in the query? This would imply that the SSN is stored in the database with the dashes so maybe I've answered my own question. You should be able to accept their input into a parameter without dashes and compare it against a copy of the SSN where you have removed the dashes from the database copy. I don't have Access installed at home so I cannot try this and show the query but I can do it at work on Monday after you've answered the questions above. ----- Original Message ----- From: Kristen K Smith <[log in to unmask]> To: <[log in to unmask]> Sent: Friday, October 13, 2000 9:48 AM Subject: [PCSOFT] Parameter queries in Access > I have a question for those of you who are experienced with Microsoft > Access 97 &/or 2000. > > I am creating a report based on a parameter query. > The query prompts the user for social security number and date. > The user for whom I am modifying this database often mistypes the '-' > character > in the social security number, and would prefer not to have to enter it at > all. > Does anyone know a way to apply an input mask on the prompt which asks for > this information? The NOSPIN Group Promotions is now offering special "Free-After-Rebate" Software specials in conjunction with Beyond.com. We have new offers all the time!!! http://nospin.com/promotions