Display only the last four digits of identification numbers
In excel I would use the RIGHT function, "=RIGHT(A1,4)." Can I do this type of function, "=RIGHT([field name],4)?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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...
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
I have set the data type as text for the account number fields.
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).
I live in South Korea.
I have a question about the field format.
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;
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.
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
However, I'm trying to print a report from that form and subform. Of course, we're back to the same problem. I need to see a report AND a subreport that display the same calculations, and I seem to be right back where I started.
On my subreport, the numbers that appeared on the form are back to displaying ####### instead of a few digits with two decimal places.