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:

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"));

Open in new window

The field i want formatted is GetPendingBalances.CardNumber
Who is Participating?
jss1199Connect With a Mentor Commented:
Same as Excel :)


colin911Author Commented:
awesome!  thanks.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.