colin911
asked on
Format Query to show only right 4 numbers
I have a query that shows 16 text characters (credit card numbers). the field from the table is formatted as text.
I want my query to show ************1223 as the card number instead of the whole number. What format characteristics do I have to give this?
I know that in excel there is a RIGHT formula where i specify the number of fields...
My SQL statement looks like this:
The field i want formatted is GetPendingBalances.CardNum ber
I want my query to show ************1223 as the card number instead of the whole number. What format characteristics do I have to give this?
I know that in excel there is a RIGHT formula where i specify the number of fields...
My SQL statement looks like this:
SELECT Batchupload.[card type] AS CardType, Batchupload.amount, GetPendingBalances.Name, GetPendingBalances.Account, GetPendingBalances.Email, GetPendingBalances.CardNumber
FROM GetPendingBalances INNER JOIN Batchupload ON GetPendingBalances.ID = Batchupload.[line num]
WHERE (((Batchupload.[batch message])="declined"));
The field i want formatted is GetPendingBalances.CardNum
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER