# Display only the last four digits of identification numbers

Views: 98

In excel I would use the RIGHT function, "=RIGHT(A1,4)." Can I do this type of function, "=RIGHT([field name],4)?

Sponsored Links:

Thank you for taking the time to report an issue.

What's wrong... Please write below.

## Similar posts...

## Access 2007: Can't Display 17 Digit Number

The numbers had initially been imported as text..which is really what they ought to be as they're identification numbers, but I had some issues using the find 'duplicate values' query and conjectured that was because the ID numbers had been defined as text---->though I could be wrong.

The VAL function works (to convert the text to numbers) but again - - I lose the detail of the last couple of digits.

I've been beating my head against this wall the entire day and at the very least, would like to know if what I'm attempting is viable. I've stumbled through function queries (with some success) and react like a deer in the headlights when it comes to VBA...

## Query that splits digits into 2 seperate fields

## If field is < 4 digits add 0's

## Integer-Based Data Types

## How to restrict a randomly assigned autonumber to 4 digits?

## Validation rule for account number field

First four digits are numbers

then a special character | -

then six digits are numbers

then a special character -

and the last three digits can be either 101 or 102

example 1234-567890-101

I have set the data type as text for the account number fields.

## Creating Part Numbers

I have been trying to create part numbers using a predetermined format. The format has three distinct categories:

division (denoted by 2 digits at the front of the part number)

category (denoted by 3 digits after the division number)

sequential number (5 digits after the category)

The completed part number will look like xx y z (the spaces are intentional). However, I would like to have the sequential number be unique for each combination of category and division. For example, the part numbers under 01 001 start at 00001 (01 001 00001) as do the part numbers for 01 002 (01 002 00001).

## Simple Format Question

I live in South Korea.

I have a question about the field format.

[Story]

Some old cell phone numbers here have 10 digits like this;

011-123-4567 or 017-123-4567 or 018-123-4567 or 019-123-4567.

Some numbers have 11 digits like this;

011-1234-5678 or 017-1234-5678 or 018-1234-5678

Most of the numbers are 11 digit numbers like this;

010-1234-5678

If I put 10 digit numbers, I want it to be showed like 011-123-4567.

If I put 11 digits, I want it to be like 010-1234-5678 or 011-1234-5678.

How can I do this?

I was thinking about this for an hour.

Still can't find out the answer.

Any help will be greatly appreciated.

## Sequential Numbering Auto "Bar-Code"

I need that Bar-code automatically assigned to a new record when registering.

Here is the Standard Example: 5555-01-001

1. Barcode Must be only in Numbers (Minimum 9 digits)

2. First 4 digits are fixed numbers (Must not be changed)

3. Second Digits are the category of the product (01 - Office Appliances, 02 - Furniture, 03 - Motor - Vehicle, 04 - Consumables)

4. And the last is Sequential numbering (001, 002, 003 etc