Solved

Remove Credit Card Input Mask

Posted on 2008-10-23
2
562 Views
Last Modified: 2012-05-05
I have a Credit Card Number text field that has an input mask:
Me.CC_Number.InputMask = "0000\-0000\-0000\-0000;0;_"

An end user wants a query that shows the Credit Card Numbers without the dashes.  How do I get rid of the dashes in a query?
0
Comment
Question by:Sasha42
  • 2
2 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 22789089


NoDashes: Replace([YourCCNumField],"-","")

mx
0
 
LVL 75
ID: 22789107
Example:

SELECT Table1.FIELD1, Table1.FIELD2, Replace([FIELD3],"-","") AS NoDashes
FROM Table1;

where FIELD3 is the CC number

mx
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question